Unanswered: How to connect to an MS Access Database
For starters, I have no scripting knoledge but I am trying to learn ASP. I have about a 2 hour train ride each day to do so (without Internet connection), and in order to work on a laptop with XP Pro, I have setup IIS and am using a MS Access database.
I have setup a Filedsn as an example I found on the web stated I should, but this doesnt seem to be connecting to the database as I cannot get the info to print to screen. I am wondering if I should use a system dsn. If so what is the code required to do this? Any good websites that have lists of code and what it does? Im really a beginner but am very willing to learn. Any good books or tips?
I made a basic database of movies that I own and thought I would pratice on that . I got everything to work fine from a SQL database (at work on a server) but I cannot get it to work with an MS Access database (I belive I am having problems connecting to the database)
database "movies.mdb" location is c:\databases
it has two feilds. Movies being the title and format being "w" for widescreen or "s" for standard