error 3622 open sql server table with identity column

[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

 

[Alex Dybenko]

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)

 

[Guest]

thanks, that worked great.

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

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