Opening Database & ASP Page Update Same Time

J

Jess

Hello,
There's an access database on an iisserver and asp makes updates to it. The
database got moved to a newer server. The users used to be able to open the
database and use the asp pages at the same time. Now when the database is
open the asp pages won't update.

Any ideas on how to change it back to the way it was?
 
B

Bob Barrows [MVP]

Jess said:
Hello,
There's an access database on an iisserver and asp makes updates to
it. The database got moved to a newer server. The users used to be
able to open the database and use the asp pages at the same time.
Now when the database is open the asp pages won't update.

Any ideas on how to change it back to the way it was?
Hard to say based on you description of the error messages you receive, but
I'm betting the problem is lack of permissions.

In order for Jet to support multi-user activity, all mdb file users must be
able to create, modify and delet a locking file with an extension of "ldb"
in the same folder that contains the mdb file. This means that all users
must be granted Change/Modify filesystem permissions for the folder
containing the mdb file. If your site uses Anonymous access, then the IUSR,
and sometimes the IWAM account requires permission. Otherwise, all users
should be put into a group that has the appropriate permissions.
 
R

Ray Costanzo [MVP]

Is there an error of some kind? What does it say? What code is erroring?
Give the symptoms!

Ray at work
 
J

Jess

Ray Costanzo said:
Is there an error of some kind? What does it say? What code is erroring?
Give the symptoms!

Ray at work
Here's the error

Error Type:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,734
Messages
2,569,441
Members
44,832
Latest member
GlennSmall

Latest Threads

Top