Multiple users of same database?

[Laurel]

Is there any way to put an access database on the server and have multiple
users use it at the same time? The existence of the ldb file suggests no.
And I can't do it with two processes on my own computer. I'd have to travel
a bit to try it out with an actual server and multiple computers. It does
seem OK to use multiple databases against the same linked backend database
(in my server scenario, I'd have to put the application database on each
computer I guess). It seems to behave more cleanly than I had anticipated.
Where would I go to read up on potential problems?

 

[Guest]

Hi Laurel,

In short, YES, but you need to split the front end (forms, reports, queries,
modules) from the back end (tables), then link the FE to the BE using
file->get external data->link.

Give each user their own copy of the FE to run on their local PC, and it
will talk to the data in the BE on the server.

Hope this helps.

Damian.