How can I use Access 2003 (SP2) with MS SQL Server 2005 Express?

[Guest]

Can I use Access 2003 (with the latest service pack to date) with MS SQL
Server 2005 Express using an ADP access project?

If so, how?

Thanks.

 

[Brendan Reynolds]

As I understand it from previous discussions in the ADP newsgroup, you can
access data in SQL Server 2005, but you can not create or modify SQL Server
2005 objects (tables, views, stored procedures, etc.). For more information,
check out the ADP newsgroup at the following URL ...

http://support.microsoft.com/newsgroups/newsReader.aspx?dg=microsoft.public.access.adp.sqlserver