Open and execute an Access query from another application?

[Guest]

Hi,

I'd like to open and execute an Access (version 2003) query from another
program using a hiperlink stored in a dbf table in the program.

The idea is that the hiperlink will give the query the value neccessary to
execute it. The program in qustion is a geographical information system,
written in Java.

Thanks in advance,

Matt

 

[Guest]

I don't know much about Java, but I think you want to do this using ADO. This
will allow you to connect to the database, declare parameters, and execute a
recordset.

Barry