Karl001
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
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
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
Kelvin
It wouldn't harm to do both.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
Only changing data, not the structure
I'm waiting the It verification regarding the security
Thanks
I'm waiting the It verification regarding the security
Thanks
Kelvin