Error with ADO Query - Assistance Needed

Hi experts,

I really need your help here.

My application is connected by ADOConnection via (DSN) to a Microsoft DB .MDB.

When the applicaton starts first time and I do a Query it works fine BUT

When I try to do a second Query I am getting the following error:

The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.

Please help it's urgent!


Who is Participating?
Pierre CorneliusConnect With a Mentor Commented:
What is your connection string?

Try setting the ADOConnection1.Mode property to cmShareDenyNone
Ashish PatelCommented:
So, try closeing the connection and record set and re-open
ST3VOAuthor Commented:
I'm Testing!!! Will get back to you :o)
ST3VOAuthor Commented:
Yep...That did the trick! Thanks a million :o)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.