Import from QUERY in another database not from table

[Emanuel Violante]

Hi,

I really need to import a union query from another database.

What I'm actually doing is importing the query as table in the query's
database, and then import that table in each user application.

The problem is that i can't get the table to be updated automatically ((

Is there any way to link directly to the query, or any other ideas?????

--
Thanks,

Sorry if my english isn''t correct, but I''m from Potugal

Emanuel Violante Galeano

 

[John W. Vinson]

Hi,

I really need to import a union query from another database.

What I'm actually doing is importing the query as table in the query's
database, and then import that table in each user application.

The problem is that i can't get the table to be updated automatically ((

Is there any way to link directly to the query, or any other ideas?????

I'm puzzled: are these user applications all on the same network or not? If
they're on the same network, why are you storing the data redundantly in each
computer, rather than using a split application where all the users share the
same data?

I think you'll need to import the union query, link to the tables, and run the
update that way... there may be an easier way though I don't see one right
away.