Solved

Error with ADO Query - Assistance Needed

Posted on 2007-12-06
4
157 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
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Show Listview image from database (String field) 5 134
CheckListBox usage 3 71
Firemonkey DbLookupComboBox equivalent ? 2 53
RESTRequest Parameter 4 41
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

789 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