linking front-end and back-end db

R

r_shawn

I need to have these two databases linked together. Does anyone know ho
to do this? Do I have to do this with code? And if I do, what do I nee
to have in the code?

If anyone can help me that would be wonderful!!

Thanks, Robi
 
M

Mike Labosh

I need to have these two databases linked together. Does anyone know how
to do this? Do I have to do this with code? And if I do, what do I need
to have in the code?
Click to expand...

Open up the "front end" database -- the one with your forms, querys, macros,
code, etc.

Click File -> Get External Data -> Link Tables

Follow the steps in the wizard.

Inside one of the sample databases that ships with Access (Northwind?
Orders? Biblio?) there is some sample VBA code that you can use and adapt
so that each time your frontend database opens, it can check, verify and if
required, relink to the backend, but this should only be neccesary if the
backend gets moved to a different path.
 
G

George Nicholson

1) Initial Linking: (From the front-end) File>GetExternalData>LinkTables.
The linked tables will appear in the FE list of tables with an arrow,
indicating that they are linked tables.

2) Link Maintenance (needed when distributing FE, updating links after
changing structure of BE, changing file locations, etc.)
Manual: Tools>Database Utilities>Linked Table Manager
Automated: "Relink Access tables from code"
http://www.mvps.org/access/tables/tbl0009.htm

HTH,
 
Top