?
Solved

Since my company ugraded from SQL Server 2005 to SQL Server 2008, could I expect this to have any impact on my  Accesss 2003 MDB type applications?

Posted on 2014-11-20
1
Medium Priority
?
192 Views
Last Modified: 2014-11-20
Since my company ugraded from SQL Server 2005 to SQL Server 2008, could I expect this to have any impact on my  Accesss 2003 MDB type applications which use SQL Server as the back end database? Should I retest my Access 2003 applications?
0
Comment
Question by:zimmer9
1 Comment
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 40455130
In general, no, but that depends entirely on exactly how you're interacting with the SQL database. Are you just using standard Linked Tables? If so, you should have no troubles.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

580 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