Web Development

Ask something
Discussion Locked

Microsoft OLE DB Provider for ODBC

0 helpful
1 reply

by roi.parris

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am unable to access a MS Access DB from an ASP page when the DB is not on a local drive.

The error displays: "The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened excusively by another user, or you need permission to view its data.

1 reply

by techrep

You have to use the fully qualified share name to identify the location of the database, not the drive letter. For example:

This doesn't work:
Db.Open "Provider=Microsoft.Jet.OLEDB.4.0; User ID=myusername;" & _
"Data Source=r:\database\mydatabase.mdb;" & _
"Persist Security Info=False;" & _
"Jet OLEDB:System database=r:\database\system.mdw"

This will work:
Db.Open "Provider=Microsoft.Jet.OLEDB.4.0; User ID=myusername;" & _
"Data Source=\\thesharename\database\mydatabase.mdb;" & _
"Persist Security Info=False;" & _
"Jet OLEDB:System database=\\thesharename\database\system.mdw"

This discussion is closed to new replies.