2 applications in 1 DB

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi,

I have actually combined two applications into a single
database.
So all the objects (tables, queries and stuff) from the
two applications can be found in the same database.
I made use of a form as the user interface. The interface
allows the user to select either "A" application or "B"
application.
How can i allow a user of "A" application to only see
objects which are applicable for "A" application and the
same goes for "B" application. User of "B" application to
see only objects which are applicable for "B" application.
 
SeRene,

To begin with, am I reading correctly through the lines that you are using a
common copy of the database, sitting on a network drive, for all users? If
yes, be warned that that situation is known to lead to frequent
corruptions... you may have not had that yet, but eventually you will!
Believe me, this is painful experience talking (under a similar scheme, I
got my first one months later).
As a general rule, a multi-user database should be split into a front and a
back end, the BE sitting on the server, while every user runs a local copy
of the FE, sitting on their PC's HDD. Browse through the access.multiuser
newsgroup, you'll find lots of helpful stuff in there.
Having said that, my suggestion is you keep the BE common for both apps (it
makes a lot of sense if there is shared data, which I presume is the case),
and make a separate FE for each application, so the access provided by each
is restricted to the relevant objects. Moreover, you get the option of
installing only the FE required for each user out of those who only need one
or the other.

HTH,
Nikos
 
Back
Top