Hi I hope someone can shed some light on this for me
I have been tasked with creating an outbound database system for multiple users. The database will receive a new batch of data on a monthly basis, so I have created an import routine to collect the relevant data that is needed and that works fine. I have created my form that picks up data depending on the criteria from my query.
The problem I am experiencing is when multiple users try accessing the form to complete the data the system just stops.
Could someone please guide me in the right direction on the best way to create my form so multiple users can scroll through each file that is not being used by , 1:Another user 2: ensure multiple users aren’t trying to access the same file.
Any help would be truly appreciated, thanks for your time