ADP and Sql Server 2005

[Ed Warren]

Is it possible to connect to SQL Server 2005 from an APD project. When I
pull down the connection menu, it only shows the SQL 2000 server and does
not show the SQL 2005 server. Am I missing something simple here?

Ed Warren

 

[Sylvain Lafontaine]

Enter manually the name of the server, followed by the name of the instance
if necessary. For example: (local)\SQL2005 .

The design tools won't work but the data will be OK.

 

[Ed Warren]

Thanks a lot, that works. I had thought I had tried that but I must have
made some 'fat finger mistake' it works like a charm now.

Ed Warren

 

[aaron.kempf]

so it lets you connect; but it won't let you write sprocs and views?

i sure hope that's a line of crap

it should work; i mean-- it's the current version of access and the
current version of sql

i think that we should all write a petition to MS to get this working
by SQL 2005 sp1

 

[aaron.kempf]

i mean.. this from the company that made access 2000 and sql 2000
incompatable.

idiots run the access dept at ms from what i see

shit; i went to some access users group meeting the other day and some
access pm couldn't write SQL to save his life.. lol

time to grow up, kids

 

[aaron.kempf]

i mean.. he was like

Select 'Aaron' From Employees
UNION
Select Firstname From Employees

i mean.. anyone else see the problem with that??