|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 17th, 2009, 03:58 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
Splitting versus Linking
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 
|
|
#2
January 17th, 2009, 04:44 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Splitting versus Linking
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  * Roger Bell wrote: 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
|
|
#3
January 17th, 2009, 05:56 AM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Splitting versus Linking
On Fri, 16 Jan 2009 19:58:01 -0800, Roger Bell
wrote: 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. -- John W. Vinson [MVP]
|
|
#4
January 17th, 2009, 05:37 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
Splitting versus Linking
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
