Multi User DB open - How to refreshdata

[SDS100UK]

Hi,

Access XP

I have a DB which is in use by 10 people max.

When they each have it open obviously it wont update with the other users inputs until it is closed and reopened.
I need to fix this.

Does any one have any ideas how to?


I would like to be able to put it on the forms timer event to refresh every 5 or 10 minutes.

Any suggestions would be greatly appreciated.

Many thanks

Steven

 

[willir]

Steven

Always a tough issue.

You could try kicking off a Refresh or Requery procedure with the Event Timer.

 

[apnetworking]

I've done the same thing successfully with Access 2000, however we use an adp database, not mdb, so I'm not positive if it's the exact same procedure.

I have a main 'workspace' form that I have open automatically when a user logs in. if they close the form, the database closes too, so it has to stay running all the time.

Go into the form properties, set the timer interval to however long you want. I use 100,000 and I think it comes out to every 3-5 minutes or something like that.

Then add an event procedure in the 'On Timer' event to run whatever refresh code you want.
Mine simply reads:
----------------------
UpdateEDIInbox
If IsAdministrator Then
CheckForImportData
End If
------------------------

I won't list my whole routines here, but here's what it does:
The 'UpdateEDIInbox' routine checks for new orders that may have been imported to a data table since the form was last opened or refreshed.
And if the logged in user is an administrator, the 'CheckForImportData' routine checks every 3-5 minutes to let them know if there is any new data to import, by enabling a button and turning the caption text red.