Solved

Error with ADO Query - Assistance Needed

Posted on 2007-12-06
4
159 Views
Last Modified: 2010-04-21
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!

Thanks

ST3VO
0
Comment
Question by:ST3VO
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 23

Expert Comment

by:Ashish Patel
ID: 20419559
So, try closeing the connection and record set and re-open
0
 

Author Comment

by:ST3VO
ID: 20420561
I'm Testing!!! Will get back to you :o)
0
 
LVL 14

Accepted Solution

by:
Pierre Cornelius earned 500 total points
ID: 20425993
What is your connection string?

Try setting the ADOConnection1.Mode property to cmShareDenyNone
0
 

Author Closing Comment

by:ST3VO
ID: 31413132
Yep...That did the trick! Thanks a million :o)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question