Is the Linking of Access tables through ODBC to SQL Server DB acheive the target?

[accesser2003]

I am developing a client-server application, which means a multi-user and concurrent connection to the database at the same time. This requires a DBMS like SQL Server, ORACLE, DB2,... which achieve this requirement.

As the MS Access is a NON multi user environment, and doesn't enable a user to read from a table if it is already has been opened by another user.

For this reason I have stored my data using the SQL Server through connecting to the SQL Server by using ODBC connection.
This is done through adding a new linked table object into its correspondent SQL Server recordset through the ODBC connection.

My question is Does this method acheive the client server connection without any difficullties in reading the data by more than one user at the same time?

Regards,

 

[RuralGuy]

Your assumptions about Access are not correct. Access is inherently Multi-User. Still, using the BackEnd you suggest will work just fine. I would make a suggestion though:
Give every user their own copy of the FrontEnd application