Access 2003 / SQL Server 2005 Data Access (not design)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are planning to roll out SQL 2005. We do all of our table/view/SP
development in Visual Studio already so loss of SQL Server design support in
Access won't be an issue for us. But...we have numerous ADPs which provide
forms UI, read and write data, call SPs and functions, generate reports, etc.
and it would be good if these continued to work.

Question: what is the *data access* story with Access 2003 and SQL Server
2005? Assuming we aren't making any design changes to the SQL database via
Access, will we encounter any issues with our forms, reports, or VBA code?
 
If you don't make any design changes, then you shouldn't encounter any
issue. If you want to be cautious, you can also choose to set the
compatibility level to SQL-2000.

However, as with everything else, there is always the possibility of one or
more bugs lurking somewhere.
 
Back
Top