Access 2000 Open Mode ?

J

Jim Bunton

I have an Access 2000 database.
I am connecting to it via web page through an aodb connection

****code snipped****
dim Cn
Set Cn=Server.CreateObject("ADODB.Connection")
Cn.Provider = "Microsoft.Jet.OLEDB.4.0"
Cn.Properties("Data Source") = "e:\. . . \Test.mdb"
Cn.Properties("User ID") = "Admin"
Cn.Properties("Password") = ""
Cn.open
set OpenConnToGoodsInStock = Cn
****end code snippet

This works fine on my original running on win 2k whilst I have the database open for development purposes at the same time as the web browser access is being made.

I have ported the application to a windows Xp machine.
On the Xp installation if the database is open then access via the aodb connection in the web application give the error

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.

[Note: I CAN run two simultaneous versions the web page application without the file already in use error]
---------------------------------------

I have checked that the database on the NEW installation is set to open in SHARED mode.


?? What's causing the sharing restriction on the Xp installation??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2000 Locked/Readonly 0
Can't find New Queries via Microsoft.Jet.OLEDB.4.0 0
Export specific fields from access to Excel 0
Provider cannot be found when opening connection 1
migrating code from Access 2000 to 2003 and 2007 5
Exporting data with vba from Excel to an Access 2007 db with password 8
Link between ADP and SQL Server 2
Why The DB Must Be Open???? 3

Top