Import from QUERY in another database not from table

  • Thread starter Thread starter Emanuel Violante
  • Start date Start date
E

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
 
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?????
Click to expand...

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.
 
Back
Top