Differenct Databases

[Guest]

Hi,

Thanks in advance. Access '2000'

I am database 'A' (C:\Home\DVD.mdb) and I wish to run a query (In DB'A')
that looks at Database 'B' (D:\Storage\DVD1.mdb) and appends records to a
file in DB'A'.

Is this possible If so how do I go about it.

Thanks

Trev

(Have thought about linking files but this will be part of a process that
looks at approx 140 other databases running through a loop (Each database
will have same table names and Field Names)

 

[Jeff Boyce]

Trevor

Are you saying that you have 140 databases, all with the same table
structure? If so, you might want to consider stepping back from what you
have and looking into normalizing your data structure.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Sorry Jeff,

Been there had the T shirt. Data would be too large for access.

At present need to keep structure. Queston Still Stands?

 

[John Vinson]

I am database 'A' (C:\Home\DVD.mdb) and I wish to run a query (In DB'A')
that looks at Database 'B' (D:\Storage\DVD1.mdb) and appends records to a
file in DB'A'.

Is this possible If so how do I go about it.

You can use the IN syntax to dynamically open any other database
accessible to your current database:

SELECT field, field, field
FROM tablename IN 'D:\Storage\DVD1.mdb'
INTO tablename;


John W. Vinson[MVP]

 

[Jeff Boyce]

Trevor

If I understand, you believe that the way your data is currently structured,
Access won't allow you to do what you want to.

You've described "how" you want to do something (140 databases, each with
its own table(s), lookup across all databases).

What I don't have a clear picture of is "why" (what is the underlying
business need/task) or "what" (what are you trying to accomplish, without
any reference to Access or Excel or any other tool)?

If you provide a bit more description of this, perhaps the newsgroup readers
can offer an alternate approach that makes better use of Access'
strengths...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/