How query Q be executed on another MDB ?

[suntisuk]

A.MDB contains linked tables from B.MDB. When query Q in
A is executed, What I understand is Q is executed in A.
So, I would like to know Is it possible to order Q to be
executed in B and send only result back to A.

I know this concept could be accomplished by using stored
procedure in backend database. But I don't have any kind
of such DBMS. With the limitation of MS-Access
environment, Could it do that ?

Regards,
Suntisuk

 

[John Viescas]

Not possible in a pure .mdb environment. Access is fundamentally a very
smart desktop flat file manager that looks like a database. All work is
done on the client machine regardless of where you put the "data" mdb file.
The closest you can come to server execution of Access mdb queries is to use
Terminal Server. Then, the client machine is just a dumb terminal running
Access on the server.

If you want the server to do more work, you must use SQL Server or MSDE
(Microsoft SQL Server Desktop Engine).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Joan Wild]

This isn't quite what you're asking (I don't think) but you can execute a
query in A that pulls data from tables in B, even though A isn't linked to B
in any way.

i.e.
SELECT * From Products In "c:\path to B.mdb";
The query will still be executed in A though.