OpenRecordset option dbSeeChanges

[Pat]

I have had to upsize an Access 2003 BE to SQL Server 2005. This means for each table in SQL Server that has an IDENTITY field i will need to add the optional parameter dbSeeChanges to each recordset used.
What i would like to know is, does it matter if i use the dbSeeChanges option on tables that dont have an IDENTITY field?
Also can it be used on local access tables?

The reason i ask is that it is easier to change all OpenRecordset commands than just the ones that use the IDENTITY field

[HansV]

You can use dbSeeChanges for local tables too, and I assume for SQL Server tables that don't have an IDENTITY field.

[Pat]

Thank you