Questions after access 2010 database has been split?
Posted on 2012-09-20
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.