How to connect an Access 2010 database to a SQL Server database on a seperate computer

Mark McCumber 431 Reputation points
2024-01-19T15:33:23.1466667+00:00

Hi All: I have a Microsoft SQL Server database stored on a separate computer MRM-WINX-002. I wish to create a Microsoft Access 2010 frontend (GUI) and have it link to the selected database on the server computer. Does anyone have illustrated Step-by-Step instructions on how to do this? Thank You, MRM256

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,302 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
272 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
798 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,938 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 39,026 Reputation points
    2024-01-22T06:41:33.1033333+00:00

0 additional answers

Sort by: Most helpful