Avatar of Karl001
Karl001
Flag for Canada asked on

Multi users problem

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
Microsoft OfficeMicrosoft Access

Avatar of undefined
Last Comment
Karl001

8/22/2022 - Mon
Kelvin Sparks

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
Karl001

ASKER
Do I have to select Edited record in the front and in the back end?
Kelvin Sparks

It would have to be the back end.

Kelvin
Your help has saved me hundreds of hours of internet surfing.
fblack61
Kelvin Sparks

It wouldn't harm to do both.
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Karl001

ASKER
I verified and come back
Scott McDaniel (EE MVE )

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)?
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
PatHartman

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

ASKER
Only changing data, not the structure

I'm waiting the It verification regarding the security

Thanks