A database I have been working on is an Access Front End with a SQL Server Back End. In a previous incarnation, the Back End was 50/50 SQL Server and local Access tables. It was a very awkward setup and I have since migrated all the tables to SQL Server. As it has been used for many years now, each user in a dozen different locations had their own Front End and hybrid Back End on their C: drive. Our DBA would rather put the Front End on a shared network drive and have everyone use it. From a maintenance and deployment perspective this makes a lot of sense. Upgrades and bug fixes would be as simple as replacing the old Front End with the new one. I would much prefer to do it this way, but I'm concerned about performance or other issues that might arise. I anticipate there wouldn't be more than 5 or 10 users at a time. So I would like to get the benefit of your experience on what the best practice is or what I need to be concerned about. I can add more detail if you need it, but I wanted to put the subject out for discussion first.