How do I add a table to the backend?

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

I had to delete a table from the backend to make changes, Not sure if it was
the best way to do that, but had to make some changes and could not access
the table. I made a copy and then deleted the original and renamed the copy
with the old name.

Now the table is not linked to the backend. I tried to just resplit the
database, that linked the table, but wiped out all the info in the other
tables.

How can I do this?
Thank you
Michael
 
Michael

The "back-end" in a split Access database is the file (nnnnn.mdb) in which
the data (tables) resides.

To put a table in the back-end, open the back-end and create or import the
table.

You don't mention from where you are trying to do this.

Regards

Jeff Boyce
<Access MVP>
 
Thanks Jeff
That wont work as the information is still stored on the computer that has
the front end. before the data for the back end was stored in a
mydatabase_be.mdb file. What I did was to create a new database and import
all the files from the frontend and then import the tables from the be file
to get a whole database again. Then I resplit that and now have a working
database with all the files split.
The strange thing is that after I resplit the file, I only have one mdb
database and not a be file.
michael
 
Back
Top