Speed up query

[elbartje]

I have an access database stored on a network drive.
I use VBA code and SQL statements to filter out the correct data from the database.
Since the database is getting bigger and bigger my code starts to slow down.
I want to split my program in a frontend (=access) and backend(=oracle database).
If I use an ADOdb connection will the querying (calcualtion) be done in database and not on the local PC ? Thus speeding up the querying ?

[PhilS]

If you use an ADO Connection to Oracle the query will be executed on the backend for sure. - This may or may not speed up the query.

Just putting the backend on a "real" database server like Oracle will not automatically make your queries fast(er). - If your queries are poorly written they might actually become even slower on Oracle.