Access split database does not reflect adding or deleting a table in the frontend

Question

I am running a Access 2007 split database. When I create, drop or rename a table on the backend it is not reflected in the frontend. If add, delete a column that is reflected. Anyone seen this?

Answer 1

This is expected, by-design behavior. Linked tables are objects in the front end that point to the back end. If objects pointed to are updated, the link will pass through those changes. But the links themselves remain unchanged.

Think of the shortcuts on your Windows desktops -- you can uninstall a computer program and its shortcut is left on the desktop (if the installer doesn't properly clean up after itself). Likewise, you can have programs installed that have no shortcut on the desktop. In short, you have to manage the linked tables yourself. When you delete a table from the back end, you have to delete the linked table that points to it. When you add a new table in the back end, you have to add a link to it in the front end.

How else could it work?

Answer 2

Yes, you have to link that new table.  It isn't going to show up automatically on its own.  When you do the initial links (unless you used the split feature from Access) you would have needed to link the tables originally.

Answer 3

Thanks much for the reply. Thinking logically it really is the only way it could work.

Thanks again!

Answer 4

Thanks much for the reply. Thinking logically it really is the only way it could work.

Thanks again!