In network approach, use Split database or one file with shortcut to every client?

Which is better to do , when I need to deploy a small application on a network!
1-      Split my ms app. To front and back end, put the back end in the server and then link all clients to it.
2-      Without splitting the ms app. , just put the app file in the server, and take a shortcut to every client.
Please help
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:

In a nutshell:
Split the DB

Front end MDB (accde) on each users workstation.
Linked into one single back end db on a server...
Jeffrey CoachmanMIS LiasonCommented:

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  #1, #1, and #1

10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Any and all cases ... Split, each user separate copy of FE. Period.

Jeffrey CoachmanMIS LiasonCommented:
I guess you asked this question for a reason...

I am sure Jim and MX can give you the more "Ethereal" explanations...

As always, you can run the db any way you want, dealing with the fallout is another issue...

Did you read the links I posted?

Sure, if you have only one user, on one machine, the single shortcut will work, ...kinda, ...for a while perhaps...
But even I would not do that.
At least with a split db (FE, mde) you can update the FE without disturbing the user(s) and the db has some basic protections, ...etc

The big issue with me a single db is that as soon as you have more than one user, if User A crashes the DB, the entire DB is dead.
With a FE/BE, the user might crash "their" FE, but this commonly leaves the BE unscathed

Besides, on a very basic, non technical level, it is simply good practice to split the db.
This helps you to identify issue with the links themselves, the way you reference the links, permissions to the target DB on the server, network connection issues, database performance (when to link to a table and when to make a table local/static), file naming, ...etc

Because of the way Access is set up to run, a single db run from a shortcut will have to pull the *entire* database over the wire.
So even with a single user, splitting the db is a good idea, if only to reduce network traffic.

Remember, the BE is on the server for some very good reasons.
The server should be accessible to all the users
The server is a "Super" machine, equipped with all manner of beefy hardware, RAIDS, backup software, power backup systems, ..etc

Again, I am sure Jim and MX can give you the more "Ethereal" explanations...
(Security concerns, Access' internal inner workings, ...etc)



DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:

I should note that all professional Access applications have the split configuration, for the following reasons

1) Possibly eliminate a problem you may be having.

2) Development on your FE can continue w/o affect live data in the back end.   A major reason to do so.

3) Testing FE changes will not affect the live data, since you can use a copy of the data BE

4) Spitting makes it much easier to plan for migration to a server database such as SQL Server, etc.

5) A split configuration allows you to create an MDE FE wherein your forms, reports and modules are secure.

6) Backing up and protecting data in the BE is *much* easier with a split configuration.

7) Users in the FE will not be able to change table designs, etc.

Again, all professional Access databases use a split configuration ... as I have for 19+ years.

After you split the db, you put a copy of the FE on each workstation - each linked to the common BE.  This will greatly help minimize many of the issues we see frequently here on EE.

Additional (must read) references on the subject:
Splitting Microsoft Access Databases to Improve Performance and Simplify Maintainability

Split your Access database into data and application

How to manually split a Access database in Microsoft Access

Jeffrey CoachmanMIS LiasonCommented:
#4, great point
Jeffrey CoachmanMIS LiasonCommented:

Access db size limit is 2GB, so with one db, this is your hard limit.
With a very basic split db, you at least then have 4GB
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Well, still only 2GB in any one back end ....but, that can be all data ...

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

 plus you can put one table in each DB if needed, so really your limit is a single table of 2GB.  But doing so precludes the use of relationships (you can't enforce relationships across containers).

Armen Stein - Microsoft Access MVP since 2006President, J Street TechnologyCommented:

And then use our free J Street Access Relinker at

Mohammad Alsolaimanapplication programmerAuthor Commented:
thank you very much for participate
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.