?
Solved

Microsoft Access and MS SQL Backend

Posted on 2013-05-19
1
Medium Priority
?
485 Views
Last Modified: 2013-05-19
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
0
Comment
Question by:Eileen Murphy
1 Comment
 

Accepted Solution

by:
Eileen Murphy earned 0 total points
ID: 39179597
Duh! Forgot to change the Identity Specification (where fields were autonums)....
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Audit trails are very important in any system to hold people responsible for certain transactions and hold them to take ownership of their actions. This article is dedicated to all novice "Microsoft Access" developers.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

601 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question