Solved

Access - FrontEnd BackEnd Question

Posted on 2014-02-26
6
571 Views
Last Modified: 2014-02-27
Hi,

I have a new database with perhaps 6 or 7 users - fairly lightweight user activity.

I will split it into backend and frontend.

It suits best (for reasons I won't go into) to simple split the database once and NOT on each users PC.   i.e. just one version of the frontend.

QUESTION: Is there benefit in splitting this way OR must I put a front end on each users PC?
0
Comment
Question by:Patrick O'Dea
6 Comments
 
LVL 61

Accepted Solution

by:
mbizup earned 100 total points
ID: 39890485
You really should put a front end on each user's computer.  That is accepted as best practice for a multitude of reasons.

- Better performance
- Less prone to corruption
- Allows you to have user-specific tables if temp tables are needed to create reports etc...
- and so on
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 100 total points
ID: 39890512
If you want to minimize pain, heartache, suffering, depression, anxiety  and a LOT more ... then put a separate copy of the FE on each user's workstation - for the reasons list by mbizup.
Until you do this .... all bets are off when problems start happening ...

mx
0
 
LVL 38

Assisted Solution

by:Jim P.
Jim P. earned 100 total points
ID: 39890598
I'll put a third vote for individual front ends, for all the same reasons.

If you are worried about version issues, there are multiple resolutions.

I have a limited term conversion utility Acc DB's that will be going out of use in a few months. I named the DB App_Convert_Util_V05.mdb. When the DB opens it does a directory search of \\Server\Share\App_Convert_Util_V*.mdb. If it finds a App_Convert_Util_V08.mdb it asks the user if they want the newer version, and then copies it to the user's desktop. The highest version is 62 currently of all the different utilities. Since I figure I'm not going to get to V99 I'm not worried.

In your case it sounds like a long term project and you have a concentrated BE, you can have a Version table in the FE and in the BE have another Version table linked to the FE. On DB open run something to compare the two tables and do a similar thing.

That will take a lot of the angst out of the problem.
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
LVL 49

Assisted Solution

by:Gustav Brock
Gustav Brock earned 100 total points
ID: 39891132
You may have your reasons, and it can be possible to run off a single FE file.

However, Access has a habit of writing temporary data into the FE and that may cause troubles. To prevent this, write-protect the physical file (right-click, Properties, mark Read-only). Then temporary data are forced into true temporary files.
This will bring up a warning when a user opens the file. That, however, can be avoided if you open the FE from a shortcut with the /runtime switch, which again may cause other troubles. But check it out.

/gustav
0
 
LVL 9

Assisted Solution

by:Armen Stein - Microsoft Access MVP since 2006
Armen Stein - Microsoft Access MVP since 2006 earned 100 total points
ID: 39892070
If you need more reasons to run the FE locally, here are two:

1. When rolling out a new version, you can't replace the old shared FE until everyone logs out.

As Jim said, a local FE can use fairly simple version checking code to check whether it is current and prompt the user to copy the latest version from the "master" on the server.

2. Related to mbizup's point about user-specific temp tables - sometimes it's handy to have session-specific queries (change the SQL property of a query in code).  These definitely need a local one-user FE.

Cheers,
Armen Stein
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39892670
Folks,  I think the message is loud and clear!!

It will definitely be a split database !!
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question