Trollina wrote:
I have a medium sized Access 2000 database that has been split into
front end/back end. I need some help understanding what to do when I
add new tables to the database that I want on the network but linked
to the front end for all the users. Do I have to re-split the
database to do this - or is there a way to link without doing this.
I think I must be missing some fundamental point on this. Can anyone
help.
Open the backend and add the tables/relationships. Compact it.
Open your copy of the frontend, and link to the new tables (File, Get
External Data, Link Tables). Make other modifications to the frontend as
needed.
Compact the frontend. Distribute the frontend to your users - just
overwrite their existing frontend.
There are a number of ways you can automate distributing the frontend.
Use a batch file to copy the frontend from the server
or
http://www.databasejournal.com/featu...le.php/3286111
or
http://www.granite.ab.ca/access/autofe.htm
--
Joan Wild
Microsoft Access MVP