Re: One Form Linked to Multiple Databases

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 01/05/05 

Date: Tue, 04 Jan 2005 19:15:10 -0700

On Tue, 4 Jan 2005 10:11:03 -0800, "Colin"
<Colin@discussions.microsoft.com> wrote:

>Thanks for your post.
>Unfortunately, every time the company program completes an order it creates
>a new database file for that specific order (i.e.: every order has its own
>.mdb file). I'm trying to find a way to link all of the databases - including
>new databases that will be continuously created with the filling of each new
>order by the company, so that the data from each order can be viewed in a
>report or form.
>Any suggestions?

Fire the designer of this system. :-{(

If their assumption is that you can only view a report on data if the
database contains no other data, then whoever designed it knows
NOTHING about Access, and damn little about databases!

No, there's no good way to deal with this mess. You'll need to use the
VBA OpenDatabase method on each database, and you'll quickly run into
the Too Many Databases error. There will be NO simple way to combine
the data.

I would suggest, if you can't avoid this system, to do an end run
around it; create a database "under the radar" of the IT department or
whoever created this piece of junk, and have code in it to open each
database as it comes along, link to the table (presumably just one
table?) in it, and Append it into the normalized single database.

                  John W. Vinson[MVP]

Relevant Pages

  • Re: Very slow response
    ... If you open a new Access database, select Tools, Options ... ... has been set to something on the LAN? ... > I entered Access, open the database file ... > Then I enter the report's design view to edit the report layout ...
    (microsoft.public.access.reports)
  • Re: GT.M V5.3-004 released
    ... Documentation tab to get to a page from which all user documentation ... data in database and journal files. ... On UNIX/Linux platforms, the database file size limit has been ... size, the largest database file that can be created is 1,792GB. ...
    (comp.lang.mumps)
  • Re: FrontPage security / writing to an Access database file
    ... I think if you do tools/ web settings/ database ... > database etc) I need to be able to write data to the database file. ... > script is by using the control panel to set the following IUSR permissions ... > POST commands from annonymous users but have contacted the hosting company ...
    (microsoft.public.frontpage.client)
  • RE: "Exclusive Access" (or lack thereof) suddenly an issue
    ... Via Windows Explorer navigate to the folder where your database file ... Microsoft Access Support ...
    (microsoft.public.access.gettingstarted)
  • Re: Digital Signature Problem
    ... I sign the Access database file with my computer’s locale setting set ... to U.S. English. ... Slovenia have told me that they see this error message on their computers ...
    (microsoft.public.access.security)