Access & MS SQL Server 2005

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,812 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,541 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

Thread Tools Display Modes

Views: 3408 | Replies: 1

•

Join Date: Nov 2006

Posts: 1

Reputation: smrtime is an unknown quantity at this point

Rep Power: 0

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

Rep Power: 0

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