Location of Queries (?)

  • Thread starter Thread starter croy
  • Start date Start date
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?
 
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.
Click to expand...

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?
Click to expand...

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/
 
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.
Click to expand...

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/
 
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.
 
Back
Top