PHWinfo - Afficher un message - SqlServer2005 with Win2k workstations running Access 2003

29/09/2006, 14h20

> As I understand, you can't use Access 2003 (or earlier) ADP/ADE
> against SQL Server 2005. To use an ADP/ADE with 2005, you must use
> Access 2007.

Absolutely not.

You CAN create ADPs with Access 2003, using SQL 2005 as back-end. I did it.
What you CANNOT do is manipulate SQL 2005 objects via Access 2003, because
SQL-DMO has significant changes from previous version.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

29/09/2006, 14h20	#4
PBsoft Messages: n/a Hébergeur:	Re: SqlServer2005 with Win2k workstations running Access 2003 > As I understand, you can't use Access 2003 (or earlier) ADP/ADE > against SQL Server 2005. To use an ADP/ADE with 2005, you must use > Access 2007. Absolutely not. You CAN create ADPs with Access 2003, using SQL 2005 as back-end. I did it. What you CANNOT do is manipulate SQL 2005 objects via Access 2003, because SQL-DMO has significant changes from previous version. -- PBsoft di Gabriele Bertolucci www.pbsoft.it skype: pbsoftsolution