By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,136 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,136 IT Pros & Developers. It's quick & easy.

Access Database Locking Up

P: n/a
I have an access database that used to be on 1 box and now is on another.
There's asp pages calling it. The gals that use it said they used to be able
to get into the access database at anytime and modify it without the asp
pages locking up. Does anyone know how this could occur?
Dec 7 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Are the users ever presented with an error message?

Ray at work

"Jess" <Je**@discussions.microsoft.com> wrote in message
news:43**********************************@microsof t.com...
I have an access database that used to be on 1 box and now is on another.
There's asp pages calling it. The gals that use it said they used to be
able
to get into the access database at anytime and modify it without the asp
pages locking up. Does anyone know how this could occur?

Dec 7 '05 #2

P: n/a
When the asp pages & database were on the old box they never got any error
messages except when I, the developer, opened the database thru file
explorer. Now it's on a different box and they too get the error message
saying it's in use by another user. And the guy updating the database thru
asp can't accomplish the updating. Which makes sense to me. Would any of
this be affected by permissions if the database was on a different share than
the web was?

"Ray Costanzo [MVP]" wrote:
Are the users ever presented with an error message?

Ray at work

"Jess" <Je**@discussions.microsoft.com> wrote in message
news:43**********************************@microsof t.com...
I have an access database that used to be on 1 box and now is on another.
There's asp pages calling it. The gals that use it said they used to be
able
to get into the access database at anytime and modify it without the asp
pages locking up. Does anyone know how this could occur?


Dec 8 '05 #3

P: n/a
All users of an Access database require Modify permissions for the folder
containing the database in order to allow multi-user activity to be allowed.
This means that if your site is using Anonymous access, then the IUSR and
IWAM accounts must b e granted Modify permissions for that folder. If using
Integrated security, then the actual users need those permissions.
Jess wrote:
When the asp pages & database were on the old box they never got any
error messages except when I, the developer, opened the database thru
file explorer. Now it's on a different box and they too get the
error message saying it's in use by another user. And the guy
updating the database thru asp can't accomplish the updating. Which
makes sense to me. Would any of this be affected by permissions if
the database was on a different share than the web was?

"Ray Costanzo [MVP]" wrote:
Are the users ever presented with an error message?

Ray at work

"Jess" <Je**@discussions.microsoft.com> wrote in message
news:43**********************************@microsof t.com...
I have an access database that used to be on 1 box and now is on
another. There's asp pages calling it. The gals that use it said
they used to be able
to get into the access database at anytime and modify it without
the asp pages locking up. Does anyone know how this could occur?


--
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"
Dec 8 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.