Location of Queries (?)

C

croy

I have long worked under the idea that only tables should
reside in the back-end.

But I noticed an article by Mr. Fenton, stating that tables
*and* queries should all reside in the back-end.

Which is the best strategy for working across a LAN? Across
a WAN?
 
T

Tony Toews

I have long worked under the idea that only tables should
reside in the back-end.
Agreed

But I noticed an article by Mr. Fenton, stating that tables
*and* queries should all reside in the back-end.

Unfortunately David passed away a year or so back so he can't defend
himself. Which he could do very well. <smile>

Do you have a URL for the article?
Which is the best strategy for working across a LAN? Across
a WAN?

That's a fairly broad question. David did stated that using an
Access back end worked well in a NY state wide application but they
were running a 100 Mpbs backbone throughout the state.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 
T

Tony Toews

I think it must have been this one:
http://dfenton.com/DFA/Replication/index.php?title=Best_Practices
Under the heading, "Split the Database". Second sentence.

Gotcha. Interesting. I have no idea. When I think about it he's
correct if it was a SQL Server database in that views are in the SQL
Server database and linked as tables in the Access FE.

But not in Access back ends. You can't link to queries in the BE.
You can't see them in the BE from within the FE. So I don't know
where he is coming from.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 
A

Access Developer

I have occasionally seen (and used) queries in a back end database when I
opened it directly for maintenance. I can't think of an instance in which
I'd put a query at some other node of a LAN or WAN for use in a production.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top