Major problem with Database splitting

  • Thread starter Thread starter Cam
  • Start date Start date
C

Cam

Hello,

I splitted the database into a FE and BE. The FE has
linked tables and all the queries, forms, reports, etc.
The BE only has the actual Tables. I distributed the FE to
users PC (C drive), the BE is in a network drive.
I understand that when users enter new data into the
FE,the data will be updated automatically. The problem I
ran into is since the users don't access the BE, they
can't view updated reports from their FE database.

It is important that users, especially Managers, need to
view and print updated reports everyday. How can I solve
this problem so that they can view updated data/reports?
Thanks
 
Cam;
From how it's describe this should not be an issue because the BE is only the data and the reports (ie: updated reports) should be static and only the data they display is different. If your users can't access the data on the BE then how is the FE working to insert or modify the BE's data?

This may be an issue that is similiar to a problem I'm having which I think has to do with Security Zones.

Dan.

----- Cam wrote: -----

Hello,

I splitted the database into a FE and BE. The FE has
linked tables and all the queries, forms, reports, etc.
The BE only has the actual Tables. I distributed the FE to
users PC (C drive), the BE is in a network drive.
I understand that when users enter new data into the
FE,the data will be updated automatically. The problem I
ran into is since the users don't access the BE, they
can't view updated reports from their FE database.

It is important that users, especially Managers, need to
view and print updated reports everyday. How can I solve
this problem so that they can view updated data/reports?
Thanks
 
Cam said:
Hello,

I splitted the database into a FE and BE. The FE has
linked tables and all the queries, forms, reports, etc.
The BE only has the actual Tables. I distributed the FE to
users PC (C drive), the BE is in a network drive.
I understand that when users enter new data into the
FE,the data will be updated automatically. The problem I
ran into is since the users don't access the BE, they
can't view updated reports from their FE database.

It is important that users, especially Managers, need to
view and print updated reports everyday. How can I solve
this problem so that they can view updated data/reports?
Thanks
Click to expand...


The reports are based on queries based on the table links to the BE or on
the links to the BE themselves. Every time you run a report it will take a
NEW look at the data in the BE and should produce updated output. If that's
not happening I suspect that your links are not pointing to the file you
think they are.
 
Hello,

I did check the link from the FE database and they are
linked to the BE properly fromt he Link Manager.
What else can I check to ensure? I open the BE database
and all the new data is added, but not the FE.
 
What appear to be tables in the FE are no more than symbolic links to
the BE table. There is NO data in the FE at all. Therefore, if there
appears to be a mismatch between what you see in the tables in the FE
from what you see in the BE, that can only mean that your FE is
pointed to the wrong BE. There is no other possible explanation.

I would delete all the tables from the FE and relink them manually
using File > Get External Data > Link Tables.
 
Back
Top