Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

Most efficient way to run a shared Access Program

Hello All,

I have an Access 2010 database on a server.  Right now the Access database is not split into a FE and BE.  I put a shortcut directly to the database on each user's desktop.  My question is, what would be the most efficient way to have them all use it?

1. Keep it as is
2. Split the database on the server into a FE and BE and connect them to the FE via a shortcut
3. Split the database on the server into a FE and BE and put a local copy of the FE on each of their machines

The forms in this database are loaded with code.  Nothing super advanced but boatloads of code.

I am not sure which way would cause the least delay and bottlenecks.

Thanks
0
alevin16
Asked:
alevin16
2 Solutions
 
mbizupCommented:
#3 is the best practice.

Each user should have his/her own local copy of the FE, linked to a shared BE on the network.

In terms of managing FE updates for multiple users, there are plenty of 'Front-End Updaters' available online which will automatically detect version changes and copy an updated front end from a shared network location to a user's computer, and the actual code to build your own FE Updater is fairly straight forward.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
As has been said, #3 is the best choice.

 By doing that, only data flows over the network and each user has their own copy of the FE, which makes things like working with temp tables easier because they won't conflict with anyone else.

Jim.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now