While working with a Microsoft Access database using linked Microsoft SQL Server tables, you may receive the following error message:
You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column
Solution: Set rst = CurrentDb.OpenRecordset("SELECT * From tblName", dbOpenDynaset, dbSeeChanges)
If you need any help implementing any of these code samples
or modifications made for your needs, please
Click Here to get a free
quote for your Microsoft
Access Development needs.
Click Here to learn more
about the WSI quoting
process.
Click Here to view some other common Microsoft Access Run-Time Errors.