How to connect to SQL Server Express

S

SailFL

According to help in Access you are suppose to be able to connect to a SQL
Server database.

So I went to File/New/Data Link Properties but when I go to New there are no
Data Link Properties. So how do I connect to SQL Server Express. I have
down loaded the Adventure Works Example and I would like to be able to play
with it.

Thanks
 
W

WendyWest

Go to File/Get External Data, in "Files of Type" choose ODBC, then choose
Machine Data Source/New/Next/SQL Server, Next, Finish. You would then type
in the server information.

Hope this helps!
 
N

Nery Gonzalez

In order to connect to a SQL Server you have to make an .adp file
Open Access -> File -> New

Adp project and then you specify all the connection properties

Hope this help you out!
 
Top