Can somone give me a detail on how to connect to 2003 Microsoft Desktop SQL via access?

I have intsalled desktop SQL.. it is running in the taskbar, but i have had no training in any classes on how to connect.

Any help would be greatly appreciated, even a link to a tutorial.

Thanks UtterAccess!

Mike Koenig

You can create a Access Project (adp) and use the connection to connect or you can link an Access Database (mdb) using ODBC. You will need to create a dsn and then link to the tables and views.

OK.. Thank you truittb

Created Access Database Project..

but what if the server is not loacted in the drop down bar?

and what is a dsn?



Edited by: techwizz on Sat Feb 12 14:10:21 EST 2005.

Is SQL server actually running? Hover your mouse over the Icon in the system tray. Does it say Running - \\YOURSERVERNAME -MSSQL Server

If it is running, try entering the server name directly in the dropdown box on the Connection Dialog box.

A DSN is as Data source file. This simple way to create one is to goto File, Get External Data, link, the on the Files of Type drop down select ODBC Databases and then use the wizard to create the DSN.

Ahh.. ok

Get external data.. i will try that in a bit.
I have to drive somewhere. I will be back..
Yes its running in the bottom right.

and thank you.. its much easier to learn from someone than to do it yourself.. google is my buddy and all, but he never answers my direct questions...lol

Thanks Again truittb
Mike Koenig

You are welcome.

Good deal.. that did the trick.. had to type the Server in by hand.

One more question if anyone reads this.. what is the data type for a autonumber in SQL server...

in both access and MySQL it is autonumber.. but i not see it in Microsoft SQL?

Thanks

You are welcome.

Use int and uncheck the allow nulls and then set the Idenity property to Yes.