I migrated my database from SQL Server 2000 to SQL Server 2008 and am testing my Access .ade file.
I get the following error in the "AfterUpdate" event of one of my text fields:
Run-time error '30014': The data was added to the database but the data won't be displayed in the form because it doesn't satisfy the criteria in the underlying record source
When I click debug, it highlights the following line of code:
Me.Dirty = False
The complete line of code is:
If Me.Dirty Then Me.Dirty = False
I'm testing it on my SQL Server 2000 database and it doesn't give me that error.
In my ade file I simply went to File --> Connection and changed the server name to the server with SQL Server 2008 and selected the database.
Any idea why this is happening?