to link the tables in MS Access FE from SQL Server and then share FE for multi user environment

[ODSCm]

Dear friends,

I am struggling for creating a ODBC data source and then link my table from SQL server. I will tell step by step what I did so far.

1- I have completed MS Access as a compact application (BE+FE) Therefore, it is not available to be used.
2- I requested my IT department of my company to enable me to reach SQL Server. They made it enabling me to connect through SQL management studio with Windows authentication. And they define my username in security field of SQL Server
3- I have created all tables completely from the beginning with all indexing and PK features and then did their relations in SQL Sever as well under the Database which IT defined for me.

Now I need to link this table to my Front End Access. However; I do not know how should I did it so that when I send my linked FE Access to my users, they can directly reach the BE without any operation. I will have 200-250 users totally. And all users have driver SQL Server in their ODBC Data sources.

My direct questions to you now will be like below;
1- As I understood, I need to first create a data source which my Access can connect from external data place in ribbon. But which one should I choose
* User DSN
* System DSN
* File DSN

2- When we come to MS Access again, from external Data tab in ribbon choosing ODBC database section gave me two option to choose --> File Data Source , Machine Data Source. Which one should be choosen?

I will appreciated for detailed help

 

[ranman256]

i use USER dsn.
i make the dsn's on the PC.
Then the FE app can grab data from the BE.

have all the BE tables linked BEFORE you deliver the FE. Then just give everyone a copy of the FE.

(link with MACHINE source)