error 3622 open sql server table with identity column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am linked to a SQL database. When I run the following code I get "error
3622 open sql server table with identity column"


Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId)

What is the cause of this error and what steps do I need to take to correct
it.

Thanks
 
try:
Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId, dbopendynaset, dbseechanges)

if you need updateable recordset

and if you need read-only:

Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId, dbopensnapshot)
 
thanks, that worked great.

Alex Dybenko said:
try:
Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId, dbopendynaset, dbseechanges)

if you need updateable recordset

and if you need read-only:

Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId, dbopensnapshot)

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com


Bob said:
I am linked to a SQL database. When I run the following code I get "error
3622 open sql server table with identity column"


Set rs = db.OpenRecordset("Select * from tblInventoryItems where
[InvoiceNbr] =" & Me!InvoiceId)

What is the cause of this error and what steps do I need to take to
correct
it.

Thanks
Click to expand...
Click to expand...
 
Back
Top