MsAccess multi user
Posted on 2011-03-09
It's several years I use msaccess,
is it possible make a db access which could be
used at the same time from several users?
Attention!: Not simple open and consulted,
I speak about the possibility to have tables
which are only of the current user.
I have a query1 that is a creation table query,
My user1 runs Query1 and create table1 which certain filters,
at the same time user2 runs Query1 and create table1 which his filters,
I would like if user1 has his table1 different from table1 of user2.
But they open the same db file...
Is it possible without copying the db for all different users?