Linking new table (1 Viewer)

[gcomp]

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]

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]

I don't see an option to delete links in the linked table manager. I'm using Access 2007.

 

[jfgambit]

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]

I'm not replacing a table, I'm adding a new one.

 

[G81]

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