MS SQL

MS SQL RSS

Access & MS SQL Server 2005

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2006

Posts: 1

Reputation: smrtime is an unknown quantity at this point

Solved Threads: 0

smrtime

Offline

Newbie Poster

Access & MS SQL Server 2005

Nov 30th, 2006

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.

Website Debut

•

Join Date: Jun 2006

Posts: 7

Reputation: RobStocks is an unknown quantity at this point

Solved Threads: 0

RobStocks

Offline

Newbie Poster

Re: Access & MS SQL Server 2005

Jan 17th, 2007

•

Originally Posted by smrtime

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