Moving look-up tables from back-end to front-end 1

[fogcity]

A little over a month ago I upgraded an application from Access 2003 to Access 2007 and split the database at the same time.

I've done a number of things to improve performance. An additional step I would like to take is moving 3 look-up tables from the back-end to the front-end.

Before I attempt this does any one have any suggestions regarding the steps to take to move the tables and update affected code?

 

[Remou]

Do you have any code that updates links? If so, you will need to exclude the front-end tables. You also need to be sure that these look-up tables are never updated with necessary data.

 

[fogcity]

Remou,

Thanks.

No, this application doesn't have any code which updates links.

The look-up tables in this application which I'm planning to move are system tables maintained by me. Changes are infrequent and planned.

One concern I do have is about the Linked Table Manager. When the tables are moved to the front-end will the Linked Table Manager automatically stop looking for the tables in the back-end and drop the tables from the list of tables? Or do I need to do something to drop the tables from the list?

 

[Remou]

It would be a good idea to remove them as links from the front end before importing, otherwise the names will be messed up. Simply deleting will do this - delete on a linked table removes the link, not the table.