View Single Post
Old October 7th, 2003, 01:16 AM
M.L.Srinivas M.L.Srinivas is offline
Registered User
Join Date: Oct 2003
Location: Hyderabad, AP, India.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access DB Connection (Jet cannot Open)

i'm trying to connect an Ms-Access DB on network thru my asp page.
That database is opened by other application in sharemode.

When I try to open a connection thru my asp page it's displaying the following message

Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '\\server\e\database\Job Manager.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Here is my code:
pt="\\server\e\database\Job Manager.mdb"
set objconn=createobject("adodb.connection")
ObjConn.ConnectionString="Provider=Microsoft.Jet.O LEDB.4.0;Data Source=" & pt & ";Persist Security Info=False"

Anybody please help me