Hello Everyone,

I have a several questions about splitting an Access database into a Front-End and Back-End.

Question1. Since the Back-End database is on the network server and linked back to the Front-End database on the Local C Drive Folder on a persons PC. What is the security issues that come up with this use in a multi_user environment. We will have about 300 users using the database and how do they know they are pulling up the most updated backed up version?

Question 2. Will the split database increase the speed? We will have persons opening and using in all parts of Alabama, North and South.


Question 3. Will the split database help us with the problem of some inviduals getting locked out of the database and unable to log back in?. Some people are blocked by other users in other parts of Alabama. The persons can go out and log back in and be back into the application.

Questions 4. Does having the FE on the Local C Drive folder on everyone's machine work best?

Question 5. How does updating the database work? Do updates occur in the FE only?

Question 6. How can I place the FE on ervyone's Local C Drive Folder? Can the user just copy and paste the most updated FE on the server and place on their Local C Drive?