split off table

[amerifax]

I have a mean database and would like to remove a couple of tables. I want to keep them, but not in this particular database. You. Want to save them into a different directory also.

The tables need to be use with the same database. but not that often. I'm trying to conserve on memory use. If I'm to depend on this database at all is it necessary to keep a supporting table within that database view, database.

If I have a table that is active, in database view, I know I'm going to be used memory. But if there listed in the left column as All Access Objects, are they use in any memory.

I guess I have two parts to this question;
1. How to spin off a table into another directory.
2. Does an object in the left column take up any memory.

Bob

 

[ChristopherL]

Hi!
For your first question.
Have you tried using an append/delete query to save your data in another table?

If not just set up a copy of your table, and you can easily append over the values for that table to your new table.