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

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
SQL Server | Other
Microsoft 365 and Office | Access | For business | Windows
0 comments No comments
{count} votes

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

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.