troubleshooting Question

DSN or DSN-Less Read only connection

Avatar of Gareth_Pointon
Gareth_Pointon asked on
Microsoft AccessASP
21 Comments1 Solution456 ViewsLast Modified:
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\jobdatabase.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?

Thanks
ASKER CERTIFIED SOLUTION
Gareth_Pointon

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 21 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 21 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros