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 Bunton wrote:
> Thanks for responding to my posting Pegasus,
>
> I've tried the Access group - no response - hence my posting here
>
> Jim
>
> "Pegasus (MVP)" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>"Jim Bunton" <(E-Mail Removed)> wrote in message
>>news:SxfDh.359592$(E-Mail Removed)...
>>
>>>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
>>>
>>>
>>
>>Best posted in an MS Access newsgroup.
>>
>>
>
>
>
|
Similar Threads
