IIS and MS ACCESS

[kleinma]

I am used to having SQL Server as the DB backend for my websites, but I'm creating one right now that uses access... in IIS do I need to specify somewhere permissions for the DB so I can connect to it? because when I try now, it says:

The Microsoft Jet database engine cannot open the file 'c:\inetpub\wwwroot\mysite\pass\database\passaccts.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

In IIS I selected the MDB file and made sure it has read and write permissions enabled

[nswan]

i've had this error and it turned out to be the connection string. Are you using the one generated by .net when you drag a connection from the server explorer window? If so then try using a basic connection string like below:

strConnection = "provider=microsoft.jet.oledb.4.0;data source=C:\Inetpub\wwwroot\test\test.mdb"

[hellswraith]

Also, if you are using Server Explorer while designing your application, makes sure it isn't connected to the database while you are running your app. I have found that to be a problem sometimes. Just right click the database in server explorer, and disconnect before running your web app.

(this is all based on the assumption that you are using the vs.net editor)