How to connect MS Access to SQL 2005?

[BridgeRE]

I'm looking for a way to run queries and whatnot from MS Access to SQL Server 2005 Databases. I do not want to convert anything, just want to use Access to connect and query. I'm not sure how to get started on this. any help?
Thanks,
Marc

 

[TheSQL]

I'm sure somebody in here can help, but you might want to post it in an MS access forum as well. It's really a question of how to connect to an external datasource from within access, if I'm not mistaken. The only thing sql-specific about it might be a connection string, if required.

I'd help but I don't know access!

 

[BridgeRE]

Will do, thank you!

 

[webcats]

BridgeRE,

You have to create an DSN on your computer to the SQL Server:

1)Go to Control Panel on your computer.
2)Open Administrative Tools.
3)Open Data Sources (ODBC).
4)Click on System DSN tab.
5)Click on Add button.
6)Choose Driver (SQL Server).
7)Name the DSN.
8)Specify the Server and click Next.
9)Select Windows NT authentication and click Next.
10)Select the default database and click Next.
11)Click Finish

Now in your Access db, click to link a table to access and choose the ODBC type of file. Choose the DSN name you just created above.







-----------------------------------------
Never, ever approach a computer saying, or even thinking, "I will just do this quickly."