Go Back   Access World Forums > Microsoft Access Discussion > Theory and practice of database design

Thread Tools Rate Thread Display Modes
Old 08-05-2015, 04:56 AM   #16
Newly Registered User
Join Date: Aug 2015
Posts: 18
Thanks: 0
Thanked 1 Time in 1 Post
rbh1090 is on a distinguished road
Re: To split or not?

When an application requires to be deployed in a multi-user environment, it is very convenient to split the database into two groups. The first contains the client application: database with forms, queries, reports, macros, and modules. The second contains only one or more database tables. The client application is distributed among all the workstations and connects to one or more databases stored on the server.

It is important to clarify that the term server is not very suitable for "Jet Engine and Access Database Engine" databases (mdb, accdb, etc) and it only refers to a shared folder on the network because no data processing task is executed on the server, but on the client.

By implementing the client – server design:
  • All users share the same information.
  • Maintenance tasks may be carried out in the application objects (forms, reports, etc,) without placing the database offline.
Perhaps the easiest method to implement this design consists of attaching all tables of the database server in the client application. For security and performance reasons, this method is not recommended for real server databases like a SQL.

rbh1090 is offline   Reply With Quote

backend , frontend , improvements , split

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Split string, execute function, delete split. Dranoweb Modules & VBA 30 11-03-2010 09:56 PM
how split one by one zaiacess Queries 5 07-29-2010 10:51 PM
Large Tables: To split or not to split. PookaTech Tables 8 08-11-2004 11:36 AM
To Split or Not to Split SAK General 9 09-01-2003 08:04 AM
db Split durdle Tables 2 08-11-2003 12:51 AM

All times are GMT -8. The time now is 06:21 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World