Link to home
Start Free TrialLog in
Avatar of LessonsLearned
LessonsLearned

asked on

Questions after access 2010 database has been split?

Note:  Currently I am using an Access 2002 database, which I have control over since it is the "design master".  I will convert it to an Access 2010 database.

I have a few questions after I have split the access 2010 database and the BE has been saved to a shared folder on the server, and FE has been copied to 10 user computers:

1.  If I (add or change or delete) a "report or query" on the FE located on my computer, I assume I then copy the FE (located on my computer) to the other 10 user computers.  Is that correct?

2.  If (add or delete) a "table" on the BE (located on a shared folder on the Server), then I assume I edit the FE that references the table and then copy the FE (located on my computer) to the other 10 user computers.  Is that correct?

3.  How do I prevent the other 10 user computers from making "design changes" to the FE (that is stored on there computer)?

Thanks for your help.
SOLUTION
Avatar of Michael Vasilevsky
Michael Vasilevsky
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
ASKER CERTIFIED SOLUTION
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 LessonsLearned
LessonsLearned

ASKER

Thank you!