Where do queries execute?

[Chris Pettingill]

I built a simple Access 2000 application for a client (i.e. Access 2K front
end and back end). I recently moved the back end to SQL Server 2000. All
of my queries are still in the Access front end. I'm unsure if Access will
bring all the data in the tables involved to the client, and then perform
the queries locally, or if the queries will run on the SQL Server. From the
posts I've read, it looks like it may depend on the content of the queries
themselves. Some of the queries could probably be changed to views on the
SQL Server if I need to, but others would be difficult to move to SQL
Server. None of the queries are defined as pass-through queries. How can I
tell where the queries will be running?

Thanks,
Chris

 

[Phobos]

If the queries are defined in Access then they will run in Access (i.e. on
the local machine).

It might be more efficient to have all that stuff done on the server (SQL
Server) and just have access forms (or VB if that is an option) for viewing
the data.

P

 

[Lynn Trapp]

If youwant SQL server to run the queries, then you will need to recreate
them as pass through queries. You will, of course, need to use the SQL
Server syntax.

 

[Chris Pettingill]

I usually work in Delphi, but the customer wanted the front end to be done
in Access, so I'm stuck. I had another look at the queries and it's going
to be hard to move them to SQL Server because some of them use functions I
defined in a module in the database. This is a low-volume DB, so for now
I'll see how the performance is, and maybe it'll be ok as is.

Thanks,
Chris