How do I get the server to run queries etc

[blaine011]

How do I get the server to run queries etc in an Access database, and then only return the data to the clients?

 

[jrbarnett]

Blaine011

You can only do that if the database connects through to a remote client/server database such as SQL Server, Oracle, MySQL or DB2. Access itself is a file based database and all code and SQL is executed on the system running the database.
To have Access execute a query on a remote client/server DBMS, create your query, then go to Query menu -> SQL Specific -> Pass Through.

You then have to type the SQL code in there as Access will just pass it to the server and return its results. Access will also be unable to syntax check it.

John

 

[blaine011]

by doing this, will it be a permanent sql query on the server that I can the integrate into forms, that other clients will be able to use?

 

[jrbarnett]

You can save the pass through query in Access which can be integrated into forms/reports etc if you wish, but it will not be saved as a view in the server, so you will need the access DB that you saved it to for other clients to use.

John