Multi-User Forms

[DBFIN]

I've created a report based on a query. The query criteria pulls from the textboxes in a form. If multiple users access the report simultaneously after entering their criteria in the form, how can I prevent each user from overwriting the others' criteria. One expert suggested temporarily storing the criteria on a personal drive that no other user can access. I don't know how to do this. Is there an easier alternative to this. I appreciate any help with this topic.

 

[CEH]

If your DB is split into "frontend"...."backend"... You shouldn't have any trouble with this. If multiple users are accessing the DB it should be split anyway.

 

[Dennisk]

it would not even matter if all your users opened the same db as a new instance of each unbound form would be opened in ram on each local pc therfore preserving each local copy of the criteria. However where it would matter, is where you have one copy of the db and the report required data placed in a temporary table then as each user produced the report the single underlying data table would have its contents changed.

 

[DBFIN]

When I created the form text boxes, I set them up so the data entry is "stored for later use", consequently they are not saved in any table. If I understand your response correctly, then this set up would prevent any conflict between multiple users, correct ?

 

[Dennisk]

it depends on where you store them. If you store the criteria in variables then they exist in RAM on each local machine. If you store the criteria in a table then the table needs to local to each user unless you store the user name ie CurrentUser() if you use workgroups ,or the Network user name from the ENVIRONMENT variable within the OS. Then each users last criteria can be retreived (Except in RAM as this is lost when the db is closed.