Can I creat folders to put tables, queries and reports?

J

Judy

I have 4 years worth of tables, queries and reports that I need to keep but
would like to get off my screen when working. Can this be done?
 
G

George King

Tables could be Exported into an Excel worksheet (right click the table and
select Export). You could then delete the table and if you needed it again,
Import the Excel worksheet, BUT !!

The queries and reports that depend on the tables that you export and delete
won't work without the table. There really not a good way to 'archive'
queries and reports.

One other possibility - Make a copy of the entire .mdb. then delete the
tables, queries and reports in the original .mdb. Another BUT !! There's
not a good way to get the reports and queries back into the original .mdb.
 
Top