Refreshing Data

[matpj]

How do I get access to refresh the data, if mutliple users are entering information on a shared drive?

 

[xaviercos]

You can use

DBEngine.Idle dbRefreshCache

to force read the new data base information.

Xavier Cos

P.D.: Sorry for my english.

 

[matpj]

Where do I type that?
I am quite new to Access, and so don't know much about the programming side of things, and all of these functions!

could you tell me what to type and where?
I would be very grateful!

 

[xaviercos]

Create a new module and write this function inside

Public Function RefreshCache() as boolean

On Error GoTo Error

DBEngine.Idle dbRefreshCache
RefreshCache = True

Exit Function

Error:
RefreshCache = False

End Function


Then you can use this function in your VBA code.