Running Queries in Another Access DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ricky - 01 Mar 2007 15:14 GMT

Hi

I have an application (MDB1) which sources data from another Access DB
(MDB2) and I was wondering if it is possible to execute a 'Make-Table' query
located in MDB2 through VBA code in MDB1?

Kind regards

Ricky

Reply to this Message

Michel Walsh - 01 Mar 2007 15:35 GMT

You can definitively *link* the table from MDB2 into MDB1 and run SQL
statements on the linked tables (that is, probably, using MDB2 tables, not
MDB1 ones). That is what occurs in a front-end/back-end application, where
MDB1 would be the front end and MDB2 the back end.

You can also Import the query, through File | Get External Data | Import...

Hoping it may help,
Vanderghast, Access MVP

> Hi
>
[quoted text clipped - 6 lines]
>
> Ricky

Reply to this Message

Wayne-I-M - 01 Mar 2007 15:36 GMT

Hi Ricky

You could use a macro in the other DB (MDB2) to run the querry - start the
macro from MDB1

Use Run app macro in MDB1

"C:\Program Files\Microsoft Office\OFFICE11\ MSACCESS.EXE " "C:\MyDocuments\
MDB2.mdb " /X SomeMacroName

Or call a shell from MDB1

Call Shell("""C:\Program Files\Microsoft office\OFFICE11\MSACCESS.EXE""
""C:\MyDocuments\MDB2.mdb""/X SomeMacroName", 1)

Hope this helps

Signature

Wayne
Manchester, England.

> Hi
>
[quoted text clipped - 5 lines]
>
> Ricky

Reply to this Message

ricky - 01 Mar 2007 15:42 GMT

Hey Wayne

Thanks for the tip, will try the macro method.

Thanks and kind regards

Ricky

> Hi Ricky
>
[quoted text clipped - 22 lines]
> >
> > Ricky

Reply to this Message