| Bob Barrows [MVP] 2007-12-16, 6:56 pm |
| Mel wrote:
> I get this error when accessing a MS access 2003 database from an ASP
> page when the database is opened in Access on the backend. When the
> database is not open on the backend it works fine!
>
All users of the database file need to be able to create, modify and
delete a locking file that has a .ldb extension in the folder that
contains the database file. This means that users need Change/Modify
permissions for the folder, not just the .mdb file. Who the users are
depends on what type of authentication your website is using. If using
Anonymous, then the IUSR_machinename account requires permission for the
folder. Otherwise, all the accounts of the users themselves need the
permissions. See:
http://support.microsoft.com/default.aspx/kb/253604
http://support.microsoft.com/default.aspx/kb/166029
http://support.microsoft.com/kb/253580/EN-US/
Once the permissions are correct, you will be able to have the database
open in Access while running web pages that also use it.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|