 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / SQL Server / ADP / November 2005ADP and Sql Server 2005
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 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.  SignatureSylvain Lafontaine, ing. MVP - Technologies Virtual-PC E-mail: http://cerbermail.com/?QugbLEWINF > 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 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 > Enter manually the name of the server, followed by the name of the > instance if necessary. For example: (local)\SQL2005 . [quoted text clipped - 6 lines] >> >> Ed Warren 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 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 sh.t; 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 i mean.. he was like Select 'Aaron' From Employees UNION Select Firstname From Employees i mean.. anyone else see the problem with that?? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.