Hello:
I am using the book "ASP Databases" by John Kaufman, and I'm struggling
with chapter 6, Connections.
I have a DSN connection to the sailors database, and I can generate an ASP
page with a connection when I say "DSN=Sailors". I can also generate
output with the following string:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=<path>\sailors.mdb"
But I get the error when I attempt to use OLE DB. This is my string:
"Provider=Microsoft.Jet.OLEDB.3.51;Data Source=<path>\sailors.mdb"
...and this is my error:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the
file '<path>\sailors.mdb'. It is already opened exclusively by another
user, or you need permission to view its data.
Since the other methods do work, and I can go back and forth between them;
I know that permissions are not at issue. Also, this is my personal PC,
and I know for certain that no one else is using this computer.
Any ideas or suggestions?
--Peter Ferber