Access & SQL Server

[glove]

I am using a form in Access 2000 to update a table on an SQL Server. When I use the code:

set rst = mydb.openrecordset("mytable&quot

I get the following error:

Run-time error '3622'
You must use the dbseechanges option with
OpenRecordset when accessing SQL Server table
that has an IDENTITY column

The Identity column in the SQL Table is a field that assigns a consecutive number to each record, like autonumber in Access. I can't find any reference to the "dbseechanges" option in the help menu.
[sig][/sig]

 

[foxdev]

dbseechanges is an optional (well, not in your case) parameter in OpenRecordSet.

See this MSDN article, which is addressing VB6 but seems to apply:

http://support.microsoft.com/support/kb/articles/Q190/6/20.ASP

[sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]