Accessing same .mdb from multiple locations

[PsyberFox]

Hi there,

Brief synopsis of my situation:
I've got several linked SQL tables in an MS Access db with a form input
screen.

Can I expect problems when opening this db to input data from multiple
locations simultaneously?

Thanks in advance...

 

[Steve Schapel]

Fox,

Yes. The recommended approach is to have a separate copy of the Access
frontend file for each user. If all of the multiple locations are
within a LAN, then an installation of the frontend on each workstation
PC is probably ideal. Otherwise, if the users are accessing the
application remotely, then a separate copy for each user on the server
(terminal server or whatever).