"Could not use '(unknown)'; file already in use."?????

I am getting the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

Using ASP:
I am assuming that I am somehow opening the .MDB exclusively but I can't find where (or I'm wrong :) ).
Checked the DSN in ODBC manager and it is not set to exclusive.

This is how I'm opening it:
    set conn = createobject("adodb.connection")
    conn.connectionstring="Provider=MSDASQL.1;Persist Security Info=False;Data Source=Test"
    conn.open


Thanks!
   - Marc
LVL 1
MarcGraffAsked:
Who is Participating?
 
dds110Connect With a Mentor Commented:
Here's an example from one of my pages:

Dim adoconn

Set adoconn = Server.createobject("ADODB.Connection")

adoconn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\jcknt01\JCSC\Db\webUsers.mdb;Jet OLEDB:Database Password=;"
0
 
dds110Commented:
you're using the wrong connection string for Access.

Try this one:

adoconn.connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DatabasePathAndName.mdb;Jet OLEDB:Database Password=;"
0
 
BubbaisBestCommented:
Marc,

It sounds like 1 of 2 things.  First is the database is open somewhere with MS Access.  If you find that then you can just close the file and be okay.  The 2nd thing is that a page didn't close everything properly.  If this is the case, make a copy of the database, delete the current one, and rename the copy back to the original name.  

Good luck,
Bubs
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
dds110Commented:
try this site for more information on connection strings

http://www.connectionstrings.com/
0
 
BubbaisBestCommented:
dds110 makes an excellent point as well.  Try his first.  bubs
0
 
MarcGraffAuthor Commented:
Thanks! And sorry for the wait!

   - Marc
0
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.