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

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-05-2015, 04:56 AM   #16
rbh1090
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
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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