View Full Version : Linking new table


gcomp
07-28-2010, 09:06 AM
I have created a new table in the backend of my database. How do I link it to the front end? Did I do this the right way or is there a better way?

jzwp22
07-28-2010, 09:09 AM
You will need to delete any linked tables in the front end and then use the linked table manager to relink to the frontend to the backend. The new table in the backend should then be linked (along with any other tables)

gcomp
07-28-2010, 09:13 AM
I don't see an option to delete links in the linked table manager. I'm using Access 2007.

jfgambit
07-28-2010, 10:02 AM
If you are replacing the existing table, just click on it and hit DELETE. However, I would rename it and then link in the new table (just in case you need to reverse what you are about to do) or make a back-up copy before you proceed.

gcomp
07-28-2010, 10:13 AM
I'm not replacing a table, I'm adding a new one.

G81
07-28-2010, 11:32 PM
Are you using ODBC linked tables?

If so click on the "External Data" tab on the ribbon > "More" in the import section > ODBC Database > Link to the datasource