Re: Working with two or more database files

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: boonjade (boonjade_at_discussions.microsoft.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 06:09:04 -0700

Thanks for the advice - never thought of the start up screen - I will have to
check it out first.

Alternatively I will have to restructure the database to incorporate two
reporting systems. There will only be about 20 to 30 users at any time but
the reporting system for the Junior and Senior school vary a great deal and
the student file is going to be gigantic if I incorporate both systems, with
students from both junior and senior schools.

"Bruce" wrote:

> If you use a single startup screen to get to either school
> system's database, from the user's point of view either
> choice is an entirely separate program. You are the only
> one who needs to know the truth. If the problem is the
> number of concurrent users I doubt you will fix that by
> sharing database objects between two separate files.
> >-----Original Message-----
> >No there isn't but the databases are reporting systems
> for a senior and
> >junior school respectively. The 2 school systems vary a
> great deal andit is
> >easier to set up two separate databases. However, staff
> are invoved in both
> >systems and would like to access both databases from the
> same main menu. I
> >could re-design the table structure to incorporate both
> systems but I fear it
> >may get too big to cope with all staff trying to get
> theri reports completed
> >at the end of each term.
> >
> >"Jeff Boyce" wrote:
> >
> >> Is there a business reason why you don't simply import
> the forms from B into
> >> A?
> >>
> >> While it is possible to do, you'll also need to connect
> the data on which
> >> the forms are based, making it available to both A and
> B. Again, it would
> >> be simpler just to import the forms and do everything
> in A -- you probably
> >> want a compelling need to use such a split approach.
> >>
> >> --
> >> Good luck
> >>
> >> Jeff Boyce
> >> <Access MVP>
> >>
> >>
> >.
> >
>

Relevant Pages

  • Re: Relational-to-OOP Tax
    ... In simple CRUD and reporting systems, ... What do you think is the alternative to the relational-to-OOP tax? ... is in the database, not classes. ... structure/model and the database noun structure/model which are fairly ...
    (comp.object)
  • Re: Ada DB bindings and APQ
    ... The database client "interface" from an object perspective ... Environment ... The connection ... This is why they began as separate ...
    (comp.lang.ada)
  • RE: "Module" option does not show up when setting permissions.
    ... It's by design. ... Access 2000 introduced the separate VBA ... Project for handling the code (notice the separate code window (VB Editor) ... an MDE database file out of it if you want to hide the source code from ...
    (microsoft.public.access.security)
  • Re: forms for tables set up as "one to one"
    ... I wish to set up a database to track all the tasks our marketing department ... file, print specs, and notes to the vendor. ... cases, the vendor, client, mailing house, etc each had separate tables. ... EstimatedDesignCost (currency) ...
    (microsoft.public.access.gettingstarted)
  • Re: a question regarding separate mdbs in Access
    ... All of the rest put into a front end mdb including Queries, ... You can separate 'code' from the actual data. ... Access Database Application with compiled VBA'). ... MS Access when it comes to various 'developer' versions hasn't been quite as ...
    (microsoft.public.data.ado)