Split database: multiple splits OK?

[Tom McMillion]

I've created a database which is going to be saved on a
network drive and used by operators at a number of
different workstations to collect/enter data.

Each user really only needs to see one of the
approximately 8 forms which will all enter data into one
common table. Nearly all of the forms are very similar
to one another, but are necessary to have as separate
forms to drive each section of the packaging plant.

I'm planning to split the database to improve performance
running over the LAN. But is it possible to in effect
devise multiple splits whereby the application that is
opened by each user doesn't contain all of the forms for
the entire database, but only the one form that he or she
needs on his or her workstation?

Just curious.
Thanks.

 

[Kevin3NF]

You could make a different front-end for each user with only the forms they
need, but keeping up with it will be a royal pain...

 

[John Vinson]

But is it possible to in effect
devise multiple splits whereby the application that is
opened by each user doesn't contain all of the forms for
the entire database, but only the one form that he or she
needs on his or her workstation?

Certainly. None of the frontends know anything about, or are affected
in any way, by any of the other frontends.

 

[Tom McMillion]

John,

Sorry if this is a $64K question, but how do I divide the
front end into multiple splits with only a certain form
or forms on each "front end"?

-----Original Message-----

Certainly. None of the frontends know anything about, or
are affected in any way, by any of the other frontends.

 

[Albert D. Kallal]

You simply create a blank mdb, import the form, and then add in the tables.
Of couse the tables will be linked. If you change the location, you use the
linked table manager

Note that if you run any applction in a multi-user envioement, you want to
run a split eniroment.

Check out:

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

http://www.microsoft.com/accessdev/articles/bapp97/chapters/ba15_3.htm

and


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