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
|
|||
|
|||
Compact and Repair
I have database that is stored on a shared network drive, its size is 685mb,
to Compact and Repair I copy the database to my desktop, Compact and Repair and get it down to 73mb, I then copy it back to the network drive. The problem is that in 5 to 10 mins. it goes back to 685mb. Any ideas or sugesstions? Thanks. |
#2
|
|||
|
|||
Compact and Repair
why can't you compact and repair it on the drive? my thing is that it's
probably the same database on the network drive .. unless you're deleting it from the network drive. and then replacing it with the new compacted version. first backup the database then compact and compres it. hth |
#3
|
|||
|
|||
Compact and Repair
The problem I have is getting everyone to close the database, there's alway
someone that has opened or minimized on their desktop, that why I can't compact and repair on the network drive, so after I compact and repair on my desktop I copy and replace the database on the network drive. " wrote: why can't you compact and repair it on the drive? my thing is that it's probably the same database on the network drive .. unless you're deleting it from the network drive. and then replacing it with the new compacted version. first backup the database then compact and compres it. hth |
#4
|
|||
|
|||
Compact and Repair
It balloons up 10x in just a few minutes? Something is really wrong there.
1. Are you sure that you aren't comparing apples to oranges? That one computer is showing MB while the other is showing KB? Probably not as this should show 1000x more. Still do a right click on the file in Explorer and see what the properties say. 2. Are you doing a lot of Make Table queries then deleting records or dropping tables? Something like temporary work tables? Are you importing in a lot of data? How about bunches of Union queries or queries with sorting and grouping? 3. Is the database split between a Front End (FE) with forms, reports, code, etc. and a Back End (BE) with just the tables? If not consider doing so ASAP. If you search on access database bloat, you will find a lot of information. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "Dryder" wrote: I have database that is stored on a shared network drive, its size is 685mb, to Compact and Repair I copy the database to my desktop, Compact and Repair and get it down to 73mb, I then copy it back to the network drive. The problem is that in 5 to 10 mins. it goes back to 685mb. Any ideas or sugesstions? Thanks. |
#5
|
|||
|
|||
Compact and Repair
In my opinion, it is a BAD idea to do this with an open database. If
someone has the database open they could be posting changes to it and you will either lose their changes or may end up with a corrupt copy of the database. You can see if the database is open by looking for the lock file (name of database.ldb) in the same folder as the data. There are ways to have the users shut down. One - threats of violent action. Two - check the newsgroups for ways to code your database to force the users' copies to shut down after a specified interval. "Dryder" wrote in message ... The problem I have is getting everyone to close the database, there's alway someone that has opened or minimized on their desktop, that why I can't compact and repair on the network drive, so after I compact and repair on my desktop I copy and replace the database on the network drive. " wrote: why can't you compact and repair it on the drive? my thing is that it's probably the same database on the network drive .. unless you're deleting it from the network drive. and then replacing it with the new compacted version. first backup the database then compact and compres it. hth |
#6
|
|||
|
|||
Compact and Repair
Why not set the "compact on close" option in Tools-Options-General. This
way, whenever someone uses it and closes the database, the Compact function is automatically run. Just a thought "Dryder" wrote: I have database that is stored on a shared network drive, its size is 685mb, to Compact and Repair I copy the database to my desktop, Compact and Repair and get it down to 73mb, I then copy it back to the network drive. The problem is that in 5 to 10 mins. it goes back to 685mb. Any ideas or sugesstions? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Compact and Repair Freezes | Dan | New Users | 1 | October 15th, 2005 04:58 PM |
Compact & Repair Removing Groups from File Security Properties | Jspagnoli | General Discussion | 3 | March 21st, 2005 10:25 PM |
Compact & Repair Corrupt Error Message | HT | Database Design | 1 | January 27th, 2005 10:18 PM |
Compact & Repair is DANGEROUS! | Mark Burns | General Discussion | 2 | December 9th, 2004 12:50 AM |
Unable to Compact and Repair | SCHNYDES | General Discussion | 3 | October 9th, 2004 10:37 PM |