Hi there,
I have a password protected Access database(database password). When I connect to this database through asp, what should be the User ID value?. I used the user ID "admin" in the ConnectionString. But, the asp file throws the error
Microsoft JET Database Engine error '80040e4d'
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Since this is not a user-based password, what should I give for the "User ID" attribute of the ConnectionString property? The Access database is not "opened exclusively by another user" as the error msg says.
What could be problem? I just want to password protect (database password only) my database and access it through ASP.
Can anybody throw light on this?
SQLNerd
I have a password protected Access database(database password). When I connect to this database through asp, what should be the User ID value?. I used the user ID "admin" in the ConnectionString. But, the asp file throws the error
Microsoft JET Database Engine error '80040e4d'
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Since this is not a user-based password, what should I give for the "User ID" attribute of the ConnectionString property? The Access database is not "opened exclusively by another user" as the error msg says.
What could be problem? I just want to password protect (database password only) my database and access it through ASP.
Can anybody throw light on this?
SQLNerd