Getting a table from the Front End to the Back End

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?
 
F

fredg

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?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top