Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Opening a recordset on an sql server table with Id Column

Status
Not open for further replies.
AmeriSource

AmeriSource

Programmer
Dec 3, 2001
17
CA
Hi, I'm trying to open a recordset on an SQL server table in Access 97. I keep getting "Error 3622. You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY COLUMN."

I use the dbSeeChanges option and I get the same error.

Thanking you in advance.

 
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
188
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
255
remeng
remeng
MattGreer
  • Locked
  • Question
Delete a Table Row in a Filtered Table 2
Replies
11
Views
431
SkipVought
S
feipezi
  • Locked
  • Question
How to pull data from MS Access DB and place on an Excel spreadsheet with WHERE clause? 2
Replies
10
Views
286
feipezi
feipezi
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
334
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top