Hows it going
i am referencing a table by using
Set Rst1 = CustDb.OpenRecordset("select firstName and secondname and a1 and a2 and customerid from dbo_tblcustomer order by firstname"
this line is returning an error message saying that you must use dbSeeChanges when accessing an SQL server (my tables are linked)table that has a IDENTITY column.
where do you place dbSeeChanges or how does it work?
its not coming up in help files
thanks alot
frank
i am referencing a table by using
Set Rst1 = CustDb.OpenRecordset("select firstName and secondname and a1 and a2 and customerid from dbo_tblcustomer order by firstname"
this line is returning an error message saying that you must use dbSeeChanges when accessing an SQL server (my tables are linked)table that has a IDENTITY column.
where do you place dbSeeChanges or how does it work?
its not coming up in help files
thanks alot
frank