Link to home
Start Free TrialLog in
Avatar of Karl001
Karl001Flag 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
Avatar of Kelvin Sparks
Kelvin Sparks
Flag of New Zealand image

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
Avatar of Karl001

ASKER

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

Kelvin
It wouldn't harm to do both.
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Karl001

ASKER

I verified and come back
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)?
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.
Avatar of Karl001

ASKER

Only changing data, not the structure

I'm waiting the It verification regarding the security

Thanks