Opening Database & ASP Page Update Same Time

11 Apr 2006 4:51 PM

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?

11 Apr 2006 5:23 PM

Bob Barrows [MVP]

Jess wrote:

> 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.

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

11 Apr 2006 5:24 PM

Ray Costanzo [MVP]

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

Ray at work

Show quote

"Jess" <J***@discussions.microsoft.com> wrote in message
news:F7FFF589-62FD-449E-A72F-6E1B7316BA37@microsoft.com...
> 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?

11 Apr 2006 5:57 PM

Jess

Show quote

"Ray Costanzo [MVP]" wrote:

> Is there an error of some kind? What does it say? What code is erroring?
> Give the symptoms!
>
> Ray at work
>
> "Jess" <J***@discussions.microsoft.com> wrote in message
> news:F7FFF589-62FD-449E-A72F-6E1B7316BA37@microsoft.com...
> > 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?
>
>
>

Here's the error

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

11 Apr 2006 6:06 PM

Bob Barrows [MVP]

Jess wrote:

> "Ray Costanzo [MVP]" wrote:
>
>> Is there an error of some kind? What does it say? What code is
>> erroring? Give the symptoms!
>>
> Here's the error
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Could not use ''; file already in use.

Bingo! I win the bet! It's definitely a permissions issue.
http://www.aspfaq.com/show.asp?id=2009

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.