ms access 97 problem 3622

[nicklewis]

error message:
you must use the dbseechanges option with openrecordset when accessing a sql server table that has an identity colum

The code:
Dim db As Database
Dim tblDowntime As Recordset

Set db = DBEngine.Workspaces(0).Databases(0)
Set tblDowntime = db.OpenRecordset("dwor_Downtime", dbOpenDynaset)

Any help would be much appreciated

 

[PHV]

You may try this (as suggested):
Set tblDowntime = db.OpenRecordset("dwor_Downtime", dbOpenDynaset, dbSeeChanges)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[nicklewis]

didnt realise it was that easy cheers for the help that worked perfectly. hopefully this will be my last problem he says

cheers again