dbSeeChanges

[David]

I have an addin db that I am trying to do a codedb.Execute "query string" but
when it runs, i get an error:

You must use the dbSeeChanges option with OpenRecordset when accessing a SQL
Server table that has an IDENTITY column.

I can't change to doCmd.Execute "query string" because the table does not
exist in the primary database.

Q: How do can I get around this problem...
Thank you for any information

 

[david epsom dot com dot au]

You must use the dbSeeChanges option:

codedb.Execute "query string", dbSeeChanges

(david)

 

[david]

I have been programming a number of years and I never even noticed that there
were options to Execute... dah... Thank you.

 

[Tony Toews]

I have been programming a number of years and I never even noticed that there
were options to Execute... dah... Thank you.

I'd also suggest using dbfailonerror.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm