Split database: multiple splits OK?

  • Thread starter Thread starter Tom McMillion
  • Start date Start date
T

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.
 
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...
 
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?
Click to expand...

Certainly. None of the frontends know anything about, or are affected
in any way, by any of the other frontends.
 
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-----
Click to expand...

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