multiuser with filters

[barret bonden]

Have a program that uses filters that's about to go multi-user; what
issues might I expect ?
As things stand the user is forced to choose a data set ( based on a code
field) when the program opens; this data is stored in a public variable and
used to set a filter in all forms and reports.
What will happen in a multi - user situation ?
Do I have to use a front and back end still for 2007 ?

 

[Douglas J. Steele]

Front-end/Back-end is definitely the correct way to go, in all versions of
Access.

 

[boblarson]

And not only frontend/backend but there should be a COPY of the frontend on
EACH user's machine. Do not try to use a single frontend file from a network
location.

See here for more about splitting and why:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm


--
Bob Larson
Access MVP
Access World Forums Administrator
Utter Access VIP

Tutorials at http://www.btabdevelopment.com

__________________________________