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 Error
I have a large database 91MB that, when I compact and repair it only gets
half way through then says "Access Has Encountered An Error and Now Must Close" then asks me to send an error report or not. I have reviewed my database and have no idea what is causing this. My only thought is that it was built in 2000 and is now running on the Jet 8.0 service pack. Any help with this is much appreciated as I really need to compact and repair this file. Thank you, Sandy S. Database Coordinator |
#2
|
|||
|
|||
I have had a similar problem. Try importing all of your tables into a new
database. This is another way to get the records "clean". Then see if you can compact the new data. "AccessDbGirl" wrote: I have a large database 91MB that, when I compact and repair it only gets half way through then says "Access Has Encountered An Error and Now Must Close" then asks me to send an error report or not. I have reviewed my database and have no idea what is causing this. My only thought is that it was built in 2000 and is now running on the Jet 8.0 service pack. Any help with this is much appreciated as I really need to compact and repair this file. Thank you, Sandy S. Database Coordinator |
#3
|
|||
|
|||
Thanks Jackie :-)
That was my last resort option but it looks like the only one that will work. Wish me luck! (Thank Goodness for Backups) "Jackie L" wrote: I have had a similar problem. Try importing all of your tables into a new database. This is another way to get the records "clean". Then see if you can compact the new data. "AccessDbGirl" wrote: I have a large database 91MB that, when I compact and repair it only gets half way through then says "Access Has Encountered An Error and Now Must Close" then asks me to send an error report or not. I have reviewed my database and have no idea what is causing this. My only thought is that it was built in 2000 and is now running on the Jet 8.0 service pack. Any help with this is much appreciated as I really need to compact and repair this file. Thank you, Sandy S. Database Coordinator |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Unable to Compact and Repair | SCHNYDES | General Discussion | 3 | October 9th, 2004 10:37 PM |
Cannot "Compact and Repair..." | Skip2Maloo | General Discussion | 4 | August 9th, 2004 06:59 AM |
Compact and Repair | HagridWTL | General Discussion | 1 | August 5th, 2004 10:31 PM |
compact and repair database | CD Tom | Using Forms | 1 | July 11th, 2004 07:50 PM |