Access 2003 and SQL Server v.9

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

Guest

What do I need to do to allow my Access Data Projects to work with the latest
SQL Server versions.
 
You only need to connect to the SQL Server2005 (menu File->Connection...) as
long as you do not create/modify SQL Server2005's server side objects
(tables, views, SPs, UDFs...) and only use the ADP to develop pure frnt-end
objects (Forms, Reports, code module...).

If you want to manipulate SQL Server2005 server side object from your ADP,
you need Access2007 (could be the last version that still support ADP).
 
You must log in or register to reply here.

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

Is Access 2003/2007 compatible with SQL Server 2008 4
Unable to make design changes in .adp connected to SQL server 2008 1
Access and SQL Server 7
Split Database vs. Access Project 3
SQL Server Backend is Read Only 7
Access to SQL Server 9
What are the steps to fix damaged MDF files in SQL Server? 0
32 bit access application and 64 bit SQL 2008 2

Back
Top