Multi-user database

[joeserrone]

I would like your opinion on this; I have a ms access database that will be used in a multi-user environment, across different Teams. Data will be loaded from text files several times a day in a MS Access table, users will retrieve the data from the tables and displayed in a form. Their job will be to add comments and select drop down boxes for actions they have taken. Since the data is downloaded in the tables and retrieved from the user instead of the user keying in the data from scratch I would like to know how to best design this. I’m thinking of having a query run to display the data in the user form but is there a way that I can have the data refreshed every so often so that users can be presented with the new records that are being downloaded. What best practice should I use to avoid conflicts like example splitting the database or using record locking options

Any help is appreciated! Thanks

 

[Guus2005]

Why/What data is loaded from text files?

What i would do or have done many times, is create a backend and a frontend. Let people log in and according to their login let them have certain privileges.

To do this you could use the build in security manager.

HTH

 

[rolaaus]

You could automatically refresh the data by user the on_timer event, but you might not want to do this unless you check to make sure someone is not in the middle of editing a record (see Dirty property). I would probably rather use the After_Update - so that whenever someone makes the eidts they need to make, then do a requery once the record they modified has been saved.