Why relink tables

  • Thread starter Thread starter karen scheu via AccessMonster.com
  • Start date Start date
K

karen scheu via AccessMonster.com

I created two mdbs. One contains my BE data and will reside on a share
network drive. The other contains the FE reports/forms, etc. THe FE mdb
contains all table links to the BE database.

My question is do I ever have to refresh the table links?

Also, I'm not sure how to secure this. The users will be able to update
only one of the tables. The rest should be read only. Do I create two
workgroup files, one for each mdb. The users should log onto the FE mdb
using a shortcut and path to the workgroup. How do I secure the backend?

Thanks,
Karen
 
If you change the table structure in the BE you will need to refresh the links.
Aprt from that I sometimes find that copying the FE to a new machine gives
poor performance until the links are refreshed.

You should secure the backend while attached to the same workgroup file that
you used for the frontend.

Peter
 
Back
Top