Need my data base to notify me

[warmunger]

"YOU MUST USE THE DBSEECHANGES OPTION WITH OPENRECORDSET WHEN ACCESSING A SQL SERVER TABLE THAT HAS AN IDENTITY COLUMN"

This is the error I get when I'm using the following code
I'am using a sql database

DoCmd.Requery
Dim db As Database
Dim rs As Recordset
Set db = CurrentDb
Set rs = db.OpenRecordset("TableName", dbOpenDynaset)
rs.MoveLast
If vTableRecordCount <> rs.RecordCount Then
vTableRecordCount = rs.RecordCount
MsgBox &quot;New Record Added&quot;
End If
rs.Close
db.Close

 

[thornmastr]

Try this:

Set rs = db.OpenRecordset(&quot;TableName&quot;, dbOpenDynaset + dbseechanges)
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[warmunger]

When I add this code it tells me that it is a invalid argument.