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
|
|||
|
|||
record deletion - mdb size
Running a program that archives files and removes records from the .mdb file, however after completion the .mdb file does not decrease in size but the records do not display if .mdb file opened in access?? Opened the .mdb file in access and deleted 10,000 records from 30,000 records, however the .mdb file is still the same size?? Are there some settings that must be set to permanently delete the records. Do not know anything about databases. Can anyone help. thanks jmk ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#2
|
|||
|
|||
record deletion - mdb size
Hi
Go to tools-Database Utilities-Compact & repair that should adjust the size correctly Toolbar options maybe different if not A2K Marc "jmk" wrote in message ... Running a program that archives files and removes records from the .mdb file, however after completion the .mdb file does not decrease in size but the records do not display if .mdb file opened in access?? Opened the .mdb file in access and deleted 10,000 records from 30,000 records, however the .mdb file is still the same size?? Are there some settings that must be set to permanently delete the records. Do not know anything about databases. Can anyone help. thanks jmk ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|