View Single Post
  #2  
Old April 10th, 2010, 06:43 PM posted to microsoft.public.access.tablesdbdesign
Daniel Pineault
external usenet poster
 
Posts: 658
Default Add table to split database

Ensure no one is working in the db (no ldb back-end file) and then you take
if offline. Do not keep a copy on your server or else people may do work
which they will loose!

Then make the modifications you require (add the new table).

Then place the back-end file back in place

Open your front-end and Import - Link the new table

Finally, once you have made the form, queries, reports,... for this new
table, distribute a new version of your front-end to all your users.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"sweeneysmsm" wrote:

I have a split Access Database on a network. I need to add a new table to the
database. Do I export it to both the front end and the back-end or do I run a
relinking module or do they just find each other "across a crowded room" when
the stars align?

Thank you for any insight.

Mary