Location of Queries (?)

croy

unread,

Feb 7, 2013, 2:57:08 PM2/7/13

to

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?

--
Thanks,
croy

Tony Toews

unread,

Feb 11, 2013, 3:36:31 PM2/11/13

to

On Thu, 07 Feb 2013 11:57:08 -0800, croy <ha...@spam.invalid.net>
wrote:

>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/

croy

unread,

Feb 11, 2013, 9:47:28 PM2/11/13

to

Thanks for the reply, Tony.

On Mon, 11 Feb 2013 13:36:31 -0700, Tony Toews
<tto...@telusplanet.net> wrote:

>On Thu, 07 Feb 2013 11:57:08 -0800, croy <ha...@spam.invalid.net>
>wrote:
>
>>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.

So sad. I will miss him. So many will miss him.

>Which he could do very well.

Absolutely no doubt!

>Do you have a URL for the article?

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.

--
croy

Tony Toews

unread,

Feb 12, 2013, 8:49:13 PM2/12/13

to

On Mon, 11 Feb 2013 18:47:28 -0800, croy <ha...@spam.invalid.net>

wrote:

>>>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.

>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.

Access Developer

unread,

Feb 17, 2013, 9:11:31 PM2/17/13

to

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.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"Tony Toews" <tto...@telusplanet.net> wrote in message
news:25slh8dv37c28tm1e...@4ax.com...