database lockup

  • Thread starter Thread starter Jim Bunton
  • Start date Start date
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??
 
Jim Bunton said:
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??
Click to expand...

Best posted in an MS Access newsgroup.
 
Pegasus
Thanks for your response to my posting -
tried Public.Access news group already - not getting abny response!

So I'm trying here!

Jim


Pegasus (MVP) said:
Jim Bunton said:
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??
Click to expand...

Best posted in an MS Access newsgroup.
Click to expand...
 
Thanks for responding to my posting Pegasus,

I've tried the Access group - no response - hence my posting here

Jim

Pegasus (MVP) said:
Jim Bunton said:
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??
Click to expand...

Best posted in an MS Access newsgroup.
Click to expand...
 
If no response out of the Access group after a couple days, you could
give the Office.misc group a try. But mention the prior non-productive
queries. ;-)

Jim said:
Thanks for responding to my posting Pegasus,

I've tried the Access group - no response - hence my posting here

Jim

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??
Click to expand...

Best posted in an MS Access newsgroup.
Click to expand...
Click to expand...
 
Back
Top