Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Record delete when import?

0 views
Skip to first unread message

MN

unread,
Dec 16, 2009, 10:54:01 AM12/16/09
to
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

unread,
Dec 16, 2009, 11:23:02 AM12/16/09
to
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
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

MN

unread,
Dec 16, 2009, 11:48:01 AM12/16/09
to
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

unread,
Dec 16, 2009, 11:57:38 AM12/16/09
to
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" <M...@discussions.microsoft.com> wrote in message
news:67AF551F-37CF-41F9...@microsoft.com...

MN

unread,
Dec 17, 2009, 4:23:03 PM12/17/09
to
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

"Jeff Boyce" wrote:

> .
>

0 new messages