Find solution
How do I connect to a SQL Server database?

Can microsoft database access connect to database on SQL server?

  • Answer:

    External Data can be linked or imported to any Access database. SQL Server through ODBC is a common option. Link leaves the data in the SQL server and lets you manipulate it, whereas import pulls it into an Access table that is no longer associated with SQL Server. You sound like you want to link. The versions of Access are a little different, but something along the line of "External Data", Link is what you want. You will then be asked for your SQL server login and you can pick the tables to link. Once linked, you can query or update the tables as if they were local. All the versions also have some sort of linked table manager that lets you repoint the tables to a different SQL server or change the stored password.

Sarianto Bayu S at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

You mean MS Access to SQL db? Connect an Access project to a Microsoft SQL Server database (ADP) Show All Hide All Some of the content in this topic may not be applicable to some languages. You can connect a Microsoft Access project (Microsoft Access project: An Access file that connects to a Microsoft SQL Server database and is used to create client/server applications. A project file doesn't contain any data or data-definition-based objects such as tables and views.) to a Microsoft SQL Server (Microsoft SQL Server database: A database in Microsoft SQL Server, it consists of tables, views, indexes, stored procedures, functions, and triggers.) database. If the Access project is already connected to a Microsoft SQL Server computer, you can change that connection. Supported Microsoft SQL Server databases You can connect an Access project to a Microsoft SQL Server 2000 or SQL Server 2005 database by using Microsoft Access 2000, Access 2002, Access 2003, and Access 2007. However, when you use Access 2000, Access 2002, or Access 2003 to connect to SQL Server 2005, you cannot make design changes to SQL Server objects, and some features of SQL Server 2005 may not work correctly. To obtain full functionality when connecting an Access project to SQL Server 2005, connect by using Access 2007 or later. Note If you are connecting to a named instance of a SQL Server 2000 or SQL Server 2005 server, your Access project client computer must have Microsoft Data Access Components (MDAC) version 2.71 or later installed. You can install MDAC 2.71 by installing Microsoft SQL Server 2000 Personal Desktop Edition from the \MSDE2000 folder on the Microsoft Office 2003 CD-ROM. --------------------------------------… Open the Access project that you want to connect to a Microsoft SQL Server. On the File menu, click Connection. If the Connection menu command is not visible, click the arrows at the bottom of the File menu to display the entire list. Note The Connection command is available only when an Access project file (a file with an .adp extension) is open. On the Connection tab in the Data Link Properties dialog box, enter a server name and the information necessary to log on to the server, and then select the database on the server. For additional information, click Help in the Data Link Properties dialog box.

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.