H
hushtech
I'm using TransferText to import data into an existing table. Import works
just as
I think it should. I have a Primary key (no duplicates) and 'new' import
data that
contains a text string that tries to add a 'duplicate' record. It's great
that it detects
the collision, but it raises a 'system' type versbose msg that says I tried
to store
a record that causes a 'key violation'. What's bad is that I cannot figure
out how
to suppress the posted message box with local error handling. I want to
handle
the error without the 'automatic' message posted by someone...VB or Access
etc.
I've tried On Error stuff -- to no avail. Is there a 'general' method of
preventing
error messages from being posted? (other than not causing errors!!)
thanks -- jack
just as
I think it should. I have a Primary key (no duplicates) and 'new' import
data that
contains a text string that tries to add a 'duplicate' record. It's great
that it detects
the collision, but it raises a 'system' type versbose msg that says I tried
to store
a record that causes a 'key violation'. What's bad is that I cannot figure
out how
to suppress the posted message box with local error handling. I want to
handle
the error without the 'automatic' message posted by someone...VB or Access
etc.
I've tried On Error stuff -- to no avail. Is there a 'general' method of
preventing
error messages from being posted? (other than not causing errors!!)
thanks -- jack