Record selection

  • Thread starter Thread starter Henry
  • Start date Start date
H

Henry

I have a form that uses a filter to select records on a
table. Works great for one user, but if I have more than
one user and they open at the same time they both go to
same record. How can I create a filter that will allow
multiple users to go to a record that is not being edited?

thanks for any help
 
Your example is a good reason why you need to split your application into
two parts:

Front end part = Code, forms, reports
Back end part = just the data tables.

While ms-access filters can, and should work in a multi-user
environment...it can be a big source of problems.

So, you should split your database into those two parts. You also REALLY
want to make sure that the front end part is installed on each pc. So, do
NOT allow multiple users into that front end. As a another good idea..you
should distribute a mde to those uses also.

For information on how to split your database..check out:

http://www.granite.ab.ca/access/splitapp.htm

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm
 
Hi, Thanks
I did split and installed FE on each PC, with the BE on
the server I still get the same issue, more help please?
 
Henry said:
Hi, Thanks
I did split and installed FE on each PC, with the BE on
the server I still get the same issue, more help please?
Click to expand...

Open up the form in design mode..and check if the filter got saved. Often
during development, I open a form by the application button, it opens, and
then I flip into design mode. If you save that form..at that point the
filter is also saved. So, probably distributed a form with a saved filter to
everyone.

Once you delete that filter, save the form,...and then create a mde to
distribute to each of your users (using a mde means users can't open up
forms in design mode anymore..and you prevent users from messing with your
application..and save valuable support calls).
 
Henry said:
So, why am I deleting the filter?? I need the filter.
Click to expand...

Yes, but you don't want the filter saved with the form!

You certainly want to apply a filter...but I don't think you want it saved!

In other words...when the form loads..and you done nothing, run no code, set
no filter.....the form is REMEMBERING the saved filter setting. You most
certainly do not want that!

When you load the form...you want to be free to apply a filter ..but after
close the form...a week later when it opens..I doubt you want that form to
remember the filter from last week!

As I said..if you open up a form in design mode when a filter was
applied..and then SAVE the form..that filter is NOW SAVED, and becomes
PERMANENT. Next time you open the form..and do nothing..the filter will have
been saved. So, as I said..open up the form in design mode..and MAKE SURE
YOU DID NOT accidentally save the filter with the form.

And, if in fact you do want the form to remember that filter (and have users
call you as to why not all records are showing)...you can certainly see how
a split front end would at least allow this to work..since each users would
at least not overwrite everyone's else's filter.

So, yes..in fact you do want to delete the forms filter...since you are
likey going to set it your self..
 
Back
Top