I've written a DLL that connects to an mdb file. I then use ASP to create an object from the DLL, and then run a method that updates the database. But I get an error on update:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
But when I update directly from ASP without using the DLL it works fine. So the database can be updated using Server.CreateObject("ADODB.Command"), but not using a DLL to do the same thing! The DLL can read the database, but not update it...
I'm using a DSN to connect, and versions
Access 2000
VB 6 to write the DLL
Microsoft 2000 server with IIS 5
Please help!
Thanks
Howard