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
|
|||
|
|||
CORRUPTION
Hi and Help
How do you find and eliminate corruption from tables |
#2
|
|||
|
|||
CORRUPTION
Take a look at http://www.granite.ab.ca/access/corruptmdbs.htm
-- Hope this helps, Daniel Pineault For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php If this post was helpful, please rate it by using the vote buttons. "Derek" wrote: Hi and Help How do you find and eliminate corruption from tables |
#3
|
|||
|
|||
CORRUPTION
And a couple mo
Recovering from corruption http://allenbrowne.com/recover.html Symptoms of corruption http://www.granite.ab.ca/access/corruption/symptoms.htm Preventing Corruption http://allenbrowne.com/ser-25.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#4
|
|||
|
|||
CORRUPTION
Hi
Thank you all, spent some time on this (2 days) The problem seem to eminate from the fact that it took 6 years to achieve a enough data to get a 5Meg data file and two weeks to jump to 15Meg. All help has been tried but file is same size. I even made an mde file thinking that would help but even as this it still seems too large. I saved the file to txt format but as I have referencial integrity on an autonumber field when I import the text file I cannot set the field back to autonumber as it is not allowed. Any ideas? thanks "Linq Adams via AccessMonster.com" u28780@uwe wrote in message news:83c7234c82683@uwe... And a couple mo Recovering from corruption http://allenbrowne.com/recover.html Symptoms of corruption http://www.granite.ab.ca/access/corruption/symptoms.htm Preventing Corruption http://allenbrowne.com/ser-25.html -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#5
|
|||
|
|||
CORRUPTION
On Sat, 10 May 2008 13:49:08 +0100, "Derek" wrote:
Hi Thank you all, spent some time on this (2 days) The problem seem to eminate from the fact that it took 6 years to achieve a enough data to get a 5Meg data file and two weeks to jump to 15Meg. All help has been tried but file is same size. I even made an mde file thinking that would help but even as this it still seems too large. 15 MByte is NOT THAT BIG. 1500MByte is getting pretty large. Did you add a picture, either to a form or report or as data? Access (versions prior to 2007) handles picture data very inefficiently. I saved the file to txt format but as I have referencial integrity on an autonumber field when I import the text file I cannot set the field back to autonumber as it is not allowed. Create the table, empty, in a new database, with referential integrity and the autonumber field set. Use File... Get External Data... Link, and select "txt" from Files of Type; and run an Append query to copy the data into the new table. If you include the autonumber field in the append, it will faithfully copy in the existing values and not increment the autonumber. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|