ASP: Website doesn't work wenn Access is open

[willempipi]

Hi, Wenn i have my database open(not mutation of tables) the website itself doesn't work anymore. I have to close Access and than it works. Does anyone have a sollution for this? Thanx in advance, Willem

[Marcie Jones]

By default, I believe Access opens in exclusive-mode, meaning only one user can have the database open at a time. Marcie http://www.codeproject.com

[Joel Lucsy]

As Datagridgirl said, Access does tend to open in Exclusive mode. But another thing to check is the permissions of the directory where the database lives. When Access opens a database it creates a ".ldb" file used for locking. I have seen it where the security rights only grants access to the owner of a file, which in your case would be Access. If exclusive is not the problem, check security rights. -- Joel Lucsy

[Anonymous]

Agree with Joel Lucsy. I connected access successfully in ODBC when access had be opened. Thus I think that is a problem of rights. When a web page is accessed IIS logins with IUSER_xxx that is not right for *.ldb file.