Access 2002 to SQL Server 2000

C

CJK

*Access 2002 front end (heavy VB) linked toAccess 2002 db*

Moving a back-end db done in access to link to same tables
exported into a SQL server 2000 db. Everything seemed
fine...When I open a form in the Access front end I get:

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

Any ideas? TIA
 

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

Access 2007 Linked tables with SQL server 2008 not showing data 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
Access 2003 and SQL Server 2005 and DAO recordset 1
SQL Server Backend: linked tables or no more bound forms ? 4
Access 2007 and connecting to SQL server 2008 6
SQL upsize 2 databases 2
Access and SQLServer Express 2005 3

Top