How to connect to SQL Server Express

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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!
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Connecting Access 2003 to SQL Server 2005 Express 4
SQL Server Backend is Read Only 7
Connecting to SqlServer 2005 Express 1
Does Microsoft recommend databases or projects to connect to SQL s 1
SQL Server 5.0 Express 1
Access 2007 and connecting to SQL server 2008 6
Trouble upsizing Access to SQL 5

Back
Top