Running MSAccess(Jet) backend query from frontend?

[VicM]

Is it possible to execute a query written on an Access(Jet) backend DB from the frontend?

I've done this using passthrough queries on a SQL backend DB. But the client has not yet made the decision to migrate to SQL.

Of course the issue is the amount of time it's taking to execute the query from the frontend over the network which includes filling a table using combinations of DLookups and If statements. So was wondering if writing the query in the backend and executing it there, then using the newly filled table as the datasource for a report would speed things up, if possible.

If so, how do I execute the query?

Thanks,
Vic

 

[dhookom]

Access isn't a database server so all computing will take place on the machine running the query.

There may be other alternatives but we don't know much about your specs.

Duane
Hook'D on Access
MS Access MVP

 

[VicM]

Duane,
Thanks for the info. I suspected as much but was hoping for a Microsoft Miracle. LOL

Vic

 

[PWise]

for one thing i would change the dlookup and iif() to joins

post you query and i will try to help