Access Database manipulation without system DSN?
Posted on 2003-10-22
I am designing a website consisting of an access database, and some ASP pages to view and hopefully edit the database information. The ISP which hosts the site won't allow me to create a system DSN, or set up anything as far as SQL goes, but I'm stuck with them because of a contract the previous web guy made. To display the data I want, i've created a file DSN in the web root and used it to access the database (no pun intended) and display the info in a table. That's fine and good, but I'm having trouble being able to modify the database. I created a Data Access Page in access, but it won't work unless opened locally on the server. What are my options for access database manipulation over the web without using either a system DSN or other server side database referencing deals?