Can Multi User Access be possible

Hello L_ter ,

Yea you can make a multi-user database.What i understand from your concept you are facing problem when multiple users are accessing database at the same time.If yours is a typical Access-Jet application, there will be some changes for performance.
The good thing is that, if you only have a small user audience,you can probably use the stripped-down version of SQL Server that
comes_free_ with Access. It is called SQL Server Desktop Edition or Microsoft
Data Engine (MSDE). Don't be misled by "optimized for 5 concurrent users"...
after 5 concurrent internal "batch operations" there are some deliberate
slowdowns, but many have reported satisfactory operation with 25 or more
active users.

As a start, you might take a look at the presentation I did for my user
group about Access as an ODBC client. That will be an easier conversion than
rewriting to Access Data Project (ADP) form, and would, as well, preserve
your option of more easily switching to a different server database should
that become desirable.

You will find something related to what you are doing in this link:

http://www.granite.ab.ca/access/sqlserverupsizing.htm

http://www.granite.ab.ca/accsmstr.htm.

Good Luck