Ms access with sql server 2012

[zeeshan.adeel]

Hellow Scholars,

I am New here. I need Step by step help from experts on following issue:

I have installed MS SQL Server 2012 on my machine and I have created a database (Test DB). Next I created ODBC connection with SQL Server and Created Form in Microsoft Access. The Problem is I want this form to be copied on other workstations on LAN so that at least 07-users can use it. How should I Proceed? Do I have to installed MS SQL Server on other workstations as well?

Please Guide.

 

[pbaldy]

You do not need to install SQL Server on workstations. You create a DSN that connects to the SQL Server, or use DSN-less code.

 

[The_Doc_Man]

And you have to have a strict split between front-end and back-end content. Essentially, nothing but tables on the SQL server. Everything else on front-end Access file. Then you make the FE file point to the SHARED BE content on the SQL file and copy that FE to your user workstations.