split database question

G

Guest

I split the database and created a new table in the backend part. Then when
I went to the front end to create a new form I don't see the new table. How
do I get it to show up in the front end?
 
A

Al Campagna

chouetteray,
Whenever you add a new table to the backend, you must "link" it to the frontend.
File/Get External Data/Link Tables... and select the new table.
 
J

John Vinson

I split the database and created a new table in the backend part. Then when
I went to the front end to create a new form I don't see the new table. How
do I get it to show up in the front end?
Click to expand...

Open the frontend; from the menu select File... Get External Data...
Link. Navigate to the backend database and select the new table. The
link will remain part of the frontend, and the new table will now be
available.

John W. Vinson[MVP]
 

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

Similar Threads

Requery creating multiple records on back end 2
VBA Multiple Line handling with Split() 1
Adding New Tables to a split Database 2
Numeric Overflow when importing text file into a linked table 6
Access 2003 front end with sql 2005 backend 7
Update Queries don't work in form 9
Create new table in split database 2
Split DB, command buttons not working from a Trusted Location 1

Top