ASP & MS Access

[DanJericho]

So, I want to use ASP & Access, and I know how to do it. But, I have a problem when I password protect the database.

I password protect it by opening the db up exclusively, Tools -> Security -> Set Database Password, and I set it to "admin", without the quotes.

In my ASP page, the connection string I use is:

"Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & Server.MapPath("books.mdb") & "; Password=admin;"

However, when I open up the asp page in Internet Explorer, I get this error:

Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/books/Default.asp, line 13

If anyone could give me some help, I'd appreciate it. Thanks in advance.

[Tekime]

I could be wrong, but I think you will need to generate a new workgrouop security file.

http://www.headwaysystems.com/accessSecurity.htm