Bob H said:
I have been playing around with different aspects/tools in Access 2007 with
an old database and decided to split it. Then I wanted to unsplit it, so
following a reply to one of my posts on how to do this a week or so back, I
imported the tables. These were then named as item name Table1 , so my
question here is, are these table1 imported back into the database so that
they are no longer in the backend of the databse?
If that is true, can I then delete the backend database?
Thanks
The normal way to unsplit is to simply delete all your links tables, and
then do the import from the back end. About the only thing to watch for is
to ensure that you deleted all the linked tables *BEFORE* you do the import
of the tables from the back end.
If you have existing links and import the table again, then you'll wind up
with a table listed twice in the table view, except the second instance of
the table will have the number appended to the end of the name.
1st import you get
you get:
customers in the table view
If you import the table AGAIN then you get
customers in the table view
customers1 in the table view
If you import the table AGAIN then you get
customers in the table view
customers1 in the table view
customers2 in the table view
You can see in the above each time you inport the table with the same name
access simply appends a number to it. So, this clash/conflict does NOT
happen if you FIRST delete your table links.
So, in your case you want to be careful because if you did not delete the
linked table, then the actual forms and reports are ALL still using the
linked table to the back end. You wind up in a situation in which you have
linked tables to the backend data, and a copy the actual table date is with
the number "1" appended to the end of all the tables.
I would be quite careful about the above process. You might import the
actual data tables into your front end but if those linked tables still show
in the table view then you setup is incorrect (those linked tables are still
active). You don't want to delete that back and data untill you sure about
this.
If you don't delete the table links, then what will happen is you'll have
the first table called
customers - it will show a link icon (it is linked to back end)
customers1 - it will be a local table
(the table customers could not be used because of our
existing
table, so access appends the number one to the link table
name).
So be careful and check the table view and check if you have tables listed
multiple times with just a increasing number appended to the table name.
This means your setup is likely incorrect.
unsplitting is easy: Just delete all your linked tables, and ***then***
import the tables from the back end....