Splitting versus Linking

[Roger Bell]

Could anyone please advise me if there is any difference between Splitting
and Linking in a Multi User environment, apart from the fact that in
Splitting the Backend only contains the tables? Which is the preffered
method in a Multi User environment?

Thanks for any help

 

[strive4peace]

Hi Roger,

not exactly sure what you are asking ...

A BE (back-end) contains tables
A FE (front-end) contains queries, forms, reports, macros, and code and
is linked to tables in one or more BEs

When you separate the tables into a BE, this is also called "splitting"
-- so a split database is a FE/BE scenario...

Access 97 was very stable and multiple users in the database seemed to
be okay. With later releases of Access, however, it has become much
better to give each user their own FE.

Splitting a database also has advantages... it is easier to update users
with a new FE and, if you have multiple users, they can all share data
while each has their own copy of the FE

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[John W. Vinson]

Could anyone please advise me if there is any difference between Splitting
and Linking in a Multi User environment, apart from the fact that in
Splitting the Backend only contains the tables? Which is the preffered
method in a Multi User environment?

Thanks for any help

Splitting and linking are the front and back of the same coin. When you split
a database into a backend (tables) and a frontend (everything else), you need
links from the frontend to the backend.

 

[Richard]

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm