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

Record Locking Access on File Share - HELP

P: n/a
Hello;
I have an access 2003 db on XP OS split with backend on sql2K. I want
to put the front end on a fileserver for easier maintenance. I have 7
users using the database at any given time.

We are experience locking issues. When multiple users are in database
they cannot save their edits. and sometimes users are locked out of the
database by ADMIN.

If I put the database front end on the users local drives, there are no
problems like this. They can all be in and save with no problem.

Does anyone know what is causing this. There are no settings in the
database that should be causing this either. I have everything set for
multi user and no record locking.

The directory on the fileshare is shared and no restrictions.

Any help would be greatly appreciated.

Oct 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
I want
to put the front end on a fileserver for easier maintenance. I have 7
users using the database at any given time.
Well, why then have your installed every other pieces of software on EACH
computer..but, then come along, and install your software shared on the
server? It is not going to be reliable (as you just found out).

I explain this problem here:

http://www.members.shaw.ca/AlbertKal...plit/index.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Oct 18 '06 #2

P: n/a
On 17 Oct 2006 15:46:20 -0700, "goodlie" <go*****@gmail.comwrote:

This utility:
http://www.granite.ab.ca/access/autofe.htm
will keep the front-ends up to date. Putting the file on the server
for everyone to use is not recommended.

-Tom.

>Hello;
I have an access 2003 db on XP OS split with backend on sql2K. I want
to put the front end on a fileserver for easier maintenance. I have 7
users using the database at any given time.

We are experience locking issues. When multiple users are in database
they cannot save their edits. and sometimes users are locked out of the
database by ADMIN.

If I put the database front end on the users local drives, there are no
problems like this. They can all be in and save with no problem.

Does anyone know what is causing this. There are no settings in the
database that should be causing this either. I have everything set for
multi user and no record locking.

The directory on the fileshare is shared and no restrictions.

Any help would be greatly appreciated.
Oct 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.