If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HouseKeeping
I'm using 2003. I have an application in which I have my Programs in one
database and my Tables, which are many, in another database. I did this just to be able to work on my forms, reports and modules and test them w/o a lot of clutter around. When I Create a table I do it in the Program database and then Copyobject to the Data (table) database and then delete the table from the Program database. The trouble is that my Program database keeps growing in size while it's running, without me adding any more objects to it. I was wondering if there is some residual of the tables that I deleted in there. I know if you delete a file from the C drive that the data is still there, just the reference in the directory is deleted. Does this kind of thing happen when you delete a table. I've noticed the same sort of thing when I'm developing an application. When I have deleted items and maybe rehashed them, if I copy the whole database for backup sometimes the size is less than the original even tho I've added several objects to it. Maybe some of the garbage got left behind. My question is Is there some kind of housekeeping you should do after running an app for a period of time?? Specifically to clean out 'phantom'? tables. Thanx -- Gil |
#2
|
|||
|
|||
Garbage information in Access? No way. dripping sarcasm
Access is notorious for this. You will want to go to Tools Database Utilities Compact and Repair. Also, you can go into Tools Options General and click on "Compact on Close", and Access will clean up the mess every time the database is closed. Sharkbyte "Gilbert 2097" wrote: I'm using 2003. I have an application in which I have my Programs in one database and my Tables, which are many, in another database. I did this just to be able to work on my forms, reports and modules and test them w/o a lot of clutter around. When I Create a table I do it in the Program database and then Copyobject to the Data (table) database and then delete the table from the Program database. The trouble is that my Program database keeps growing in size while it's running, without me adding any more objects to it. I was wondering if there is some residual of the tables that I deleted in there. I know if you delete a file from the C drive that the data is still there, just the reference in the directory is deleted. Does this kind of thing happen when you delete a table. I've noticed the same sort of thing when I'm developing an application. When I have deleted items and maybe rehashed them, if I copy the whole database for backup sometimes the size is less than the original even tho I've added several objects to it. Maybe some of the garbage got left behind. My question is Is there some kind of housekeeping you should do after running an app for a period of time?? Specifically to clean out 'phantom'? tables. Thanx -- Gil |
#3
|
|||
|
|||
Gilbert
In addition to Sharkbyte's response, be aware that the Compact & Repair function (and the Compact on Close option) can sometimes fail to complete. If this happens, your db could be corrupted beyond your wildest dreams g. As a "safe computing" practice, consider creating a backup of your .mdb (you call it "Program", the generic term is "front-end") BEFORE you try Compact/Repair. Good luck Jeff Boyce Access MVP "Gilbert 2097" wrote in message ... I'm using 2003. I have an application in which I have my Programs in one database and my Tables, which are many, in another database. I did this just to be able to work on my forms, reports and modules and test them w/o a lot of clutter around. When I Create a table I do it in the Program database and then Copyobject to the Data (table) database and then delete the table from the Program database. The trouble is that my Program database keeps growing in size while it's running, without me adding any more objects to it. I was wondering if there is some residual of the tables that I deleted in there. I know if you delete a file from the C drive that the data is still there, just the reference in the directory is deleted. Does this kind of thing happen when you delete a table. I've noticed the same sort of thing when I'm developing an application. When I have deleted items and maybe rehashed them, if I copy the whole database for backup sometimes the size is less than the original even tho I've added several objects to it. Maybe some of the garbage got left behind. My question is Is there some kind of housekeeping you should do after running an app for a period of time?? Specifically to clean out 'phantom'? tables. Thanx -- Gil |
#4
|
|||
|
|||
Thank you very much for your quick reply Sharkbyte & Jeff. I haven't tried
it yet but it sounds like just the thing I need. Thanx for the warning Jeff; I will do a backup b/4 I compact. Ciao for now, -- Gil "Jeff Boyce" wrote: Gilbert In addition to Sharkbyte's response, be aware that the Compact & Repair function (and the Compact on Close option) can sometimes fail to complete. If this happens, your db could be corrupted beyond your wildest dreams g. As a "safe computing" practice, consider creating a backup of your .mdb (you call it "Program", the generic term is "front-end") BEFORE you try Compact/Repair. Good luck Jeff Boyce Access MVP "Gilbert 2097" wrote in message ... I'm using 2003. I have an application in which I have my Programs in one database and my Tables, which are many, in another database. I did this just to be able to work on my forms, reports and modules and test them w/o a lot of clutter around. When I Create a table I do it in the Program database and then Copyobject to the Data (table) database and then delete the table from the Program database. The trouble is that my Program database keeps growing in size while it's running, without me adding any more objects to it. I was wondering if there is some residual of the tables that I deleted in there. I know if you delete a file from the C drive that the data is still there, just the reference in the directory is deleted. Does this kind of thing happen when you delete a table. I've noticed the same sort of thing when I'm developing an application. When I have deleted items and maybe rehashed them, if I copy the whole database for backup sometimes the size is less than the original even tho I've added several objects to it. Maybe some of the garbage got left behind. My question is Is there some kind of housekeeping you should do after running an app for a period of time?? Specifically to clean out 'phantom'? tables. Thanx -- Gil |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
create a housekeeping check sheet on excel | beginner500 | New Users | 2 | April 24th, 2005 12:55 AM |
?outlook housekeeping problem | jeffroleigh | General Discussions | 3 | January 16th, 2005 05:20 AM |