By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

How to bypass msgbox for PK violations on TransferText import?

P: n/a
ms
In Access 2000, I am using...

'Import Raw text to stageBMIDLog table.
DoCmd.TransferText acImportFixed, "BMIDLog Link Specification",
"stageBMIDLog", file

....to import raw records into a staging table with 3-key PK. When duplicates
are attempting import, I receive a msgbox stating the number of records that
violated the PK and asks if I want to continue.

How do I remove that msgbox and complete the rest of the import? I want this
import to complete in the background automatically.

Thank you.

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Wed, 25 Feb 2004 15:33:56 -0800, ms wrote:
In Access 2000, I am using...

'Import Raw text to stageBMIDLog table.
DoCmd.TransferText acImportFixed, "BMIDLog Link Specification",
"stageBMIDLog", file

...to import raw records into a staging table with 3-key PK. When duplicates
are attempting import, I receive a msgbox stating the number of records that
violated the PK and asks if I want to continue.

How do I remove that msgbox and complete the rest of the import? I want this
import to complete in the background automatically.

Thank you.


DoCmd.SetWarnings False
DoCmd.TransferText acImportFixed, _
"BMIDLog Link Specification", "stageBMIDLog", file
DoCmd.SetWarnings True
--
Mike Storr
www.veraccess.com
Nov 12 '05 #2

P: n/a
ms
Works! Thanks for the help.

Mike Storr wrote:
On Wed, 25 Feb 2004 15:33:56 -0800, ms wrote:

In Access 2000, I am using...

'Import Raw text to stageBMIDLog table.
DoCmd.TransferText acImportFixed, "BMIDLog Link Specification",
"stageBMIDLog", file

...to import raw records into a staging table with 3-key PK. When duplicates
are attempting import, I receive a msgbox stating the number of records that
violated the PK and asks if I want to continue.

How do I remove that msgbox and complete the rest of the import? I want this
import to complete in the background automatically.

Thank you.

DoCmd.SetWarnings False
DoCmd.TransferText acImportFixed, _
"BMIDLog Link Specification", "stageBMIDLog", file
DoCmd.SetWarnings True

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.