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

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?
 
S

Sylvain Lafontaine

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 and SQL Server 2005 3
Access 2000 ADP and SQL Server 2005 2
Access 2003 or 2007 Compatible with SQL Server 2008 6
Reaching Access 2003 datas via SQL Server 2005 64 bits 2
Access 2003 & SQL Server 2005 4
Access 2003 Project connecting to SQL 2005 2
SQL Server 2005 schema for Access 2007 ADP 2
Performing a Query against Access 2003 from SQL Server 64 bit? 1

Top