Multi users problem

Karl001
Karl001 used Ask the Experts™
on
Hi,

I have an Access database, with front & back end.
I had set up the default open mode with Shared, in the Advanced Access Options
All users have the read/write authority
But If we have 2 or more users using the same table, no one can't make changes.

Any solution?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You haven't indicated which  version of Access. You need to set the record locking to the Edit Record. If Access 2010, goto the Access Options, choose Client Setting and under the advanced section, ensure that edited record is selected.


Kelvin

Author

Commented:
Do I have to select Edited record in the front and in the back end?
It would have to be the back end.

Kelvin
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

It wouldn't harm to do both.
Distinguished Expert 2017
Commented:
The default record locking is optimistic and unless you changed it, it is already set to share.  DO NOT CHANGE IT.  If the users cannot share the database, the problem is with their Active directory permissions.

Access creates a lock file when it opens.  The lock file is the same name as the database with a .laccdb or .ldb file type depending on whether you are using ACE or Jet.  If the user doesn't have permission to create a file in the shared folder, then Access opens the database in exclusive mode and that will keep anyone else from updating.  Then when the last person closes the database, Access deletes the lock file.

The lock file is critical to the multi-user operation of Access.  That is where Access keeps track of who is doing what.

Talk to your IT support and tell them that every user needs CRUD (create, read, update, and delete) permission for the folder that holds the BE.  Each user should have his own personal copy of the FE so there would not be a sharing issue with the FE.

Author

Commented:
I verified and come back
Most Valuable Expert 2012
Top Expert 2014

Commented:
But If we have 2 or more users using the same table, no one can't make changes.
Also, what do you mean by "make changes"? Are you referring to changes in the database structure (like adding a Field to a table) or changing data (like update a Customer's Address data)?
Distinguished Expert 2017

Commented:
Scott makes a good point.  From Access 2007 on, Access will NOT allow design changes when the database is opened by more than one person.  This was always a poor practice anyway and now it is just not allowed.

Always keep a separate development copy of the database.  Make your object changes there.  Test them.  Then distribute a new copy of the FE to all the users.  Assuming you have the standard split FE/BE, replacing the FE gives the users all the new/changed features and leaves their data intact.

Author

Commented:
Only changing data, not the structure

I'm waiting the It verification regarding the security

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial