I found that by using an ADO connection, I can execute my queries stored on my back-end database. Is this any better or worse that executing them by using currentproject.connection on the local machine?
I like storing them on the back end because that way I can do away with my table links completely and by using ADO connections only link to the back end database when I need it (much like a web application).

Where in relation to your app is your Access database being stored? When you say back-end, is this DB stored on a different server? Sorry, I don't quite understand what the question is.

What are you using for back end database Access? SQL Server, Oracle, etc.



Sal

I am using Access 2000 as back end. I was surprised you could execute a query stored on the back end because everything I have read said you can't. Of course, I'm sure it is executed on the front end.