467,081 Members | 1,213 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

Not Exclusive access

Is there a way to make changes (updates) in an access file which doesn’t have exclusive access? This file is in a network shared folder, and when somebody opens the file first, he/she has Write + Read Attributes and, the rest of the users have Read Only. This doesn’t allow making important changes when we need. Not until everybody is off. It is becoming an issue because a lot of people need to open this file at any time and/or at the same time. Any suggestion to solve this problem will be greatly appreciated.
Thank you in advanced

Plaguna
Oct 1 '08 #1
  • viewed: 1324
Share:
4 Replies
DonRayner
Expert 256MB
Is there a way to make changes (updates) in an access file which doesn’t have exclusive access? This file is in a network shared folder, and when somebody opens the file first, he/she has Write + Read Attributes and, the rest of the users have Read Only. This doesn’t allow making important changes when we need. Not until everybody is off. It is becoming an issue because a lot of people need to open this file at any time and/or at the same time. Any suggestion to solve this problem will be greatly appreciated.
Thank you in advanced

Plaguna
Try Tools-Options-Advanced... Make sure that the "Open database with record level locking" checkbox is checked and then just above that set the default record locking to "edited record"
Oct 1 '08 #2
I tried what you suggested and, for some reason It still doesn’t work.
Oct 1 '08 #3
DonRayner
Expert 256MB
I tried what you suggested and, for some reason It still doesn’t work.
You need to setup user level security on your database so that users will have to log in with a user id and password. If you are not using the security then the database will treat everyone who logs in as the same default user. Is your database one access mdb file that is shared out or do you have it split into a front end and back end?
Oct 2 '08 #4
NeoPa
Expert Mod 16PB
Any time you try to make any design changes to objects in your database it will change the open mode of the database to exclusive.

It's not a good idea to make such changes to a live / production database. I suggest you keep a development / test copy where changes are made and release changes when the database is otherwise unused.
Oct 12 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Uwe C. Schroeder | last post: by
1 post views Thread by Chuck Van Den Corput | last post: by
reply views Thread by Wayne | last post: by
1 post views Thread by University of Toronto | last post: by
18 posts views Thread by Andre Laplume via AccessMonster.com | last post: by
reply views Thread by MSDN | last post: by
17 posts views Thread by teddysnips@hotmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.