Forums
This topic is locked
Connection error on desktop using PWS
Posted 13 Mar 2002 22:31:05
1
has voted
13 Mar 2002 22:31:05 Terry Lyons posted:
I am using Personal Web Server over Windows 95 (a corporate thing). I have the latest MDAC loaded into my machine. I can set Connections from Modify to a DSN and it will test well. But when I try to create a recordset I always get a "Microsoft ODBD Access Driver Records cannot be read- no read permissions on Table-x" error. The Access db was created by me on the same desktop and no password was used in it's creation. I have tried setting up a DSNless connection using different connection strings but none of them work either: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("Forum.mdb" AND DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.Mappath("Forum.mdb" . What more can I do?