View Single Post
  #3  
Old April 10th, 2010, 06:55 PM posted to microsoft.public.access.tablesdbdesign
sweeneysmsm
external usenet poster
 
Posts: 74
Default Add table to split database

Hi, Daniel,

Thank you for your so-speedy reply.

One question: When you say "Open your front-end and Import - Link the new
table", are you saying that I first Import the table, and then link it, or
do you mean to go to Get External Data but choose link instead of import. Or
do you mean import the structure of the table and then Link it? Just want to
be sure that I understand exactly what you are saying.

Mary
"Daniel Pineault" wrote:

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