Record delete when import?

[MN]

Hi, I am using Access2K. When I import a table1 of File1.mdb to File2.mdb I
got an error message: "Record is deleted"- So, I coundn't import it. Any
sugggestion please?
Thank you in advance. MN

 

[Jerry Whittle]

You may have a corrupt database. I would try a compact and repair of both
databases.

Below are some more sources on Access database corruption.

Tony Toews has an excellent web page on database corruption.
Http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
Http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database.
Click on "Whittle, Jerry" on this page:
http://www.rogersaccesslibrary.com/forum/default.asp?C=1

 

[MN]

I got it ! I compact & repair database then it work now.
Thank you for advise. I wonder why I forgot this important thing !???
Thank-Thanks a ton-Best Regards.MN

 

[Jeff Boyce]

Is this the first time this has happened? In how long? Do you have
backups?

Jerry pointed out the use of the Compact & Repair feature. Be sure to do a
backup before using it.

Is there a chance that this database is split, and installed on a network
(either LAN or WAN)? These might be a factor in causing corruption...

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[MN]

Thank you for your recomendation.
Yes, this is the first time happen in 1 day then I repaired it success. I do
have a backup every day. I am OK now.
Thanks