Problems with writing to database

[nephilim]

I recently made a website that uses ASP to read and write from and to a Access 97 database.
The hosting service wouldn't allow me to use an ODBC DSN,
so I had to change the code so that it wouldn't.
Locally the site works fine, but after upload....when I try to write to the database, I get the following message?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access 97 Driver] Operation must use an updatable query.

Can anyone tell me what to do about it?

Thanks in advance.

 

[vasah20]

you need to have your isp make your db writable.

the best thing to do might be to have your ISP make an entire directory writable, this way if you ever add DB's or start writing to files on your server, you won't have to contact your ISP each time to make them set the permissions.

good luck

 

[GDX]

Make sure that the folder your database is in has access to allow the IUSR_<ComputerName> account to have write access to the database file itself or you can make a new folder like vasah20 said, hope this helps Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371