Access World Forums

Access World Forums (
-   Tables (
-   -   db Split (

durdle 08-07-2003 12:32 PM

db Split

I have another db split FE/BE question. Here's how I figure it, you go to the Tools---->Database Utilities---->Make MDE File. One you specify the located of the Front End(I want to put it on the network, any thought?). So once I completed that I opened the FE and the tables and queries were there. I though the way it worked was that the FE only had the Forms and Reports and the tables and queries was located in the BE(I also have it one the network).
Any opinions on what I should do here?
I didn't want to put FE's the users machines becasue there are 30 or 40 work station's. I guess I could put the FE on the network and get the users to copy that to there local machines?

Any help would be great

lincoln continental mark vii history

Pat Hartman 08-07-2003 12:47 PM

The be contains ONLY tables. The fe contains all the other objects. When you look at the tables tab in the fe, you will see linked tables as well as local tables. You can tell the difference because linked table names have a black arrow (for Access tables) or a Globe (for ODBC tables) to the left of the table name.

neileg 08-11-2003 12:51 AM

It's not clear why you want to split the db.

If you want all users to use the same FE, why copy it to their local machine? Why not let them run the FE from the server? There are reasons why one way is better than the other, depending on the circumstances.

All times are GMT -8. The time now is 07:54 PM.

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