Multi-User Question

[myke50]

Hi. I have a question regarding how Access 2000 treats the following scenario.

Two users are simultaneously entering data on a form located in a shared database file. I have parameter queries that are run based on certain data existing on the aforementioned form.

From what user will the paramater queries get its information?

 

[janeatwork]

Hi myke50,

The simple answer is both users. A basic example is that if the parameter was say based on a country and user 1 entered USA, user 1 would get results for USA, similarly if user 2 entered UK, user 2 would get results for UK.

For more info, do a search in Access help, copy and paste this to the Type keywords box: Share an Access database on a network