VBA access insert query does not return an error

Question

I have an Access database and i have a field attributed with unique indexed values. The problem is that when i execute an SQL insert statement with a duplicate value it does not raise an error it rather just skips the statement as if an On Error Resume Next statement is present above it.

Here is the gist of my code CurrentDb.Exceute "Insert Into IS24 (geocodes, realestateId) values (123456, 7788339)" So if 7788339 is already present it will simply not do the insert but would not raise an error either.

Sergey S. · Accepted Answer · 2016-09-28 09:33:47Z

2

Try this:

CurrentDb.Execute "Insert Into IS24 (geocodes, realestateId) values (123456, 7788339)", dbFailOnError

edited Sep 28, 2016 at 9:33

answered Sep 19, 2016 at 10:22

Sergey S.

6,3461 gold badge17 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA access insert query does not return an error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related