Database split - reverse???

  • Thread starter Thread starter Stan
  • Start date Start date
S

Stan

I have split my database (that was painless!!) so that the "back-end" is on
my server HDD and the forms etc are on my work station.
Now I want to transfer the whole database to another workstation that is not
on this network - how do I put my database back together again.
Read all the books but they don't tell how to reverse it.......
Many thanks

Stan
 
Delete the linked tables from the front-end and import them from the
back-end.
 
Stan said:
I have split my database (that was painless!!) so that the "back-end" is on
my server HDD and the forms etc are on my work station.
Now I want to transfer the whole database to another workstation that is not
on this network - how do I put my database back together again.
Read all the books but they don't tell how to reverse it.......
Many thanks

Stan
Click to expand...


Take a backup of the front and back end before taking any advice from
strangers...

Go into the front end and delete all the linked tables. These should have
little arrows next to them to show they are linked tables not actual tables,
and the warning when you go to to delete them should make this clear too.
Then select File>Get External Data>Import and import the real tables back
into the front end. This front end has now become the non-split database
with all tables, forms, reports, etc.
 
Make a copy of your front end. Open the front end (not copy) to the database
window - tables. Delete all the tables that have an arrow on the left side
of the table name. Then click on File - Get External Data - Import. Navigate
to the backend file. Click on Select All. Click on OK. Your tables, queries,
forms and reports should now be in the same database. If all was successful,
delete the copy.
 
Hi guys,
Thanks for the prompt replys.
My splits have been perfectly restored (and I still have a gravelly
voice!!!!)
Many thanks

Stan
 
Back
Top