We have a loced access DB thats been used by other programs on the network.
I have a ASP scrip that just needs to read the information in and there and thats it.
I need to force the ASP script to be Read Only on the ASP as I'm getting the following error:
The Microsoft Jet database engine cannot open the file '\\fileserver\ET_Database\
e.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have set the lock types to Read only but this is failing on the connection.
This is the connection code:
MM_ET_DB_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\fileserver\ET_Database\jobdatabase.mdb;adModeRead"
Is there a way we can force this to open the DB in Read only and ignore the access DB lock file?