Getting a table from the Front End to the Back End

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A while back I split an Access Database for a client. They have asked me to
add a table to the database with associated forms, reports and querys. Now
that I have done the work, the table associated with the new work is in the
front end of the file. How do I export(?) it to the back end?
 
A while back I split an Access Database for a client. They have asked me to
add a table to the database with associated forms, reports and querys. Now
that I have done the work, the table associated with the new work is in the
front end of the file. How do I export(?) it to the back end?
Click to expand...

Easiest way for me is to open the front end. Click
File + Export
Follow the instructions. Navigate to the back end Db.
Make sure you check the 'with data' box.

Then click
File + Import + Get External Data + Link table
Link the table to the front end.

If you need to establish a relationship with the new table, open the
back end and do it there.
 
Back
Top