I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL server 2005?
Thanks.

I usually use Access 2000 (adp) to connect to my SQL Server 2000 and work with records. I have been testing out MS SQL Server 2005 but can't seem to get it to work with Access adp. Does anyone know if you can no longer use access adp in SQL server 2005?
Thanks.

I've seen some information that says that with Access 2000 (ADP) you will not have the capability to create or modify SQLS 2005 database objects in an Access project (ADP), only to use it as a front-end connected to a "finished" SQLS 2005 database that is running in SQLS 2000 compatibility mode.

Regards

Rob

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.