Access Run-time error '30014'

Hi all.

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

Open in new window


The complete line of code is:
If Me.Dirty Then Me.Dirty = False

Open in new window


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?
Sim1980Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
The ADP is limited to specific SQL versions.  Are you sure that your Access version supports SQL Server 2008?  Try creating a new app that links to your SQL Server 2008 tables to confirm.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
Basically, then segment of code saves the current record, ...so try these variations:

    DoCmd.RunCommand acCmdSaveRecord

Or this:

If Me.Dirty =True Then
    Me.Dirty = False
End If

...or even just this:

    Me.Dirty=False

If none of these work, ...then please continue on with Pat.

JeffCoachman
0
Sim1980Author Commented:
Thank you for the replies. Jeffrey, that didn't work so I I checked to see if the adp file worked with 2008 and it didn't until I changed the version of the SQL database to 2008 (100), then it worked again.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.