I am working my way thru the Web Wiz ASP tutorials and am up to the one about adding data to an MS Access database, but when my program attempts to open the ADO coonection I get this error:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft
Jet database engine cannot open the file 'c:\myhtml\guestbook.mdb'. It is
already opened exclusively by another user, or you need permission to view its
data.
/myhtml/Add_to_Guestbook.asp, line 10
I am using a datalink (i.e a .udl file) rather than a connection string to access the database as that is what I have always done with VB. The "Test Connection" button on the datalink works fine.
There is no other user or program accessing the Access database. This is a standalone Windows XP Pro machine with IIS installed on it, so no network. And I restarted the machine to make sure there was no other process with a lock on the database.
Can anyone help.
Topic Options
Post Options
Thanks(0)
Actually there is no IUSR listed, but there is a User so I ticked it's write permisssion and everything is working fine now. Thanks very much.