Re: One Form Linked to Multiple Databases

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

From: Colin (Colin_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 04:33:01 -0800

>
> 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]
>*************************
Thanks again.
I have talked to a few people who have a similar set up. Their answer was
they had to hire a guy to create a program that did what I believe you
suggested to do. That is not an option for me. I'm interested in trying to
code a new database as you suggested, however my programming experience is
pretty limited. Do you have any sample code I could use as a guide or know of
how I could find out some more on this particular subject?
Here is what I have to be able to do:
1. Some how be able to have the code go along and convert all of the
database files (1 per order) from access 97 to 2003.
2. Have this new database go along via code and pluck chosen data (e.g.: the
cost of a particular order or the cost of all of the orders in a particular
week) out of their individual databases and show the data in the new database
in a table. (Getting sort of confused here now).
I'm sure the coding behind such a task is out of my league - but if I knew
where to start I'd give it a go.

  

Relevant Pages

  • Re: WHY
    ... Drives me absolutely nuts when I ask someone for a report on something and they ... program broken out into the various cost buckets that we use. ... The first 'analyst' has no real concept of what is in the data, ... because "it's in the database". ...
    (microsoft.public.excel)
  • Re: Having difficulty refactoring a DB application
    ... > I have a sensible database definition that more or less works for the ... OO is all about minimizing cost of certain future changes. ... the adapter itself - for example ensuring that the middle layer does ...
    (comp.object)
  • RE: .NET equivalent commands in Access VBA
    ... The true cost of software is not the cost to build it, ... the database is already split in that some of the data I read is ... I think I can call a command prompt from within Access so I ... Can I use .NET commands in Access? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Multiplicity, Change and MV
    ... and SQL Server were making enough gains in tackling some of the ... seeing significant cost savings when they use products such as U2 from ... reading the database (unless they suffer the cost of the SQL-MV ... "upgrade" to a SQL DBMS to get the missing features, ...
    (comp.databases.theory)
  • RE: Subtotal for a record
    ... I have made all changes to a backup of my original database so ... SELECT SerialNumber, PartNumber1 as PartNumber, Cost1 as Cost ... when I changed my data entry form to have all three ...
    (microsoft.public.access.reports)