Found sets

[Ted]

Hello

I have a database whcih was originally developed as a single user stand
alone. It is important in this database for users to be able to perform a
find to retieve a given set of records and then move through these to
perform various manual actions. The found set needs to be retained while
other operations occur so taht it can be returned to at any time. To allow
for this I have a boolean field called matchedlastsearch which is set to
true for the foud records when a find is run.

Now the users want to make it a multiple user database (although never with
more than three users). My exisiting solution now fails becuase while one
user is using tehir found set another may perform a find and reset the
matchedlastsearch field to identify a different set of records.

Does anyone have advice on how this type of feature can be incouded in a
multiuser database so that each user can have their own unique found set of
records recorded?

Many thanks

Ted

 

[Larry Linson]

You should split the database into front-end and back-end, and you can keep
user-specific information in the front-end. However, if you will explain in
some detail just what you are trying to accomplish by what you are doing,
not just how you are doing it, perhaps someone could offer a suggestions for
doing it in a way that would be simpler and easier (but, of course, it is
not necessarily so that there is a different way that accomplishes your
purpose).

Larry Linson
Microsoft Access MVP