Microsoft Access and MS SQL Backend

Hi Experts!

I am migrating a backend database to SQL Server from Access and I know there are some things I'll need to change in the code.

I can't recall what I need to check. I'm getting ODBC errors and I think it has something to do with my OpenRecordset calls...

I added the dbOpenDynaset, dbSeeChanges and am still getting the errors.

Any Suggestions?

Thanks, Eileen
Eileen MurphyIndependent Application DeveloperAsked:
Who is Participating?
 
Eileen MurphyIndependent Application DeveloperAuthor Commented:
Duh! Forgot to change the Identity Specification (where fields were autonums)....
0
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.

All Courses

From novice to tech pro — start learning today.