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

 

[Darth Vodka]

firstly: if you're pulling in lots of flatfiles everyday, write a table with them all in and write a routine in VBA to go down the table pulling them in

secondly: yeah a query with a form on top sounds good for users tinkering, if the query is complicated you want to try setting it to inconsistent updates (properties>data>recordsetype)

as for regular updates, try a Me.Refresh or a Me.Requery (Me is the form object if run in a form) in VBA on either a button or you can set the timer of a form to refresh (form>Properties>ontimer)

 

[rsmonkey]

note that access performance is pretty sluggish if their are more than say 10-15 users using it similtaneously over a network... if its available to aloada people who are gonna update it every so often so to speak then forget wat i sed!