dbSeeChanges

G

Guest

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
 
D

david epsom dot com dot au

You must use the dbSeeChanges option:

codedb.Execute "query string", dbSeeChanges

(david)
 
G

Guest

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

Tony Toews

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dbseechanges error 3622 2
dbSeeChanges with SQL linked tables 1
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
query error 4
must use dbSeeChanges option with Recordset 5
dbSeeChanges are already there 6
Access 2003 and SQL Server 2005 and DAO recordset 1
Delete Query with SQL Back-end error 1

Top