TransferText "Database was unable to append..." message
From: Kevin (anonymous_at_discussions.microsoft.com)
Date: 03/31/04
- Next message: Daniel P: "Re: Seperate Alpha Numeric values"
- Previous message: Daniel P: "Return the line where an error occured"
- In reply to: Ken Squid: "TransferText "Database was unable to append..." message"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 12:22:41 -0800
Do you have any fields that are Indexed and cannot accept
duplicate values? Also, check your Allow zero length
Field setting properties. Just a wild guess.
>-----Original Message-----
>Hi all,
>
>I've been trying to figure out this porblem for a week,
with no luck. Here's my issue...
>
>I am running the following line of code while importing a
text file into an table:
>
>DoCmd.TransferText , , strTableName, gStrAppPath +
strTableName + "Upload.txt"
>
>If I step through the code the code works flawlessly. If
I run the code, sonetimes it works fine, sometimes it
throws the following message:
>
>Database was unable to append all the date to the table.
The contents of fields in 0 record(s) were deleted, and 0
record(s) were lost due to key violations.
>
>I've tried throwing doEvents in all over the code, along
with timer loops, to try to "give the CPU a break", all to
no avail.
>
>Has anyone seen this, and better yet, have some ideas for
me to try?
>
>Thanks,
>Ken
>
>.
>
- Next message: Daniel P: "Re: Seperate Alpha Numeric values"
- Previous message: Daniel P: "Return the line where an error occured"
- In reply to: Ken Squid: "TransferText "Database was unable to append..." message"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
