A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

FE/BE question



 
 
Thread Tools Display Modes
  #11  
Old June 1st, 2008, 01:15 AM posted to microsoft.public.access.tablesdbdesign
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default FE/BE question

To be honest, I've never looked that closely at it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
Douglas

Have you noticed any (serious) performance issues with FE-on-LAN (instead
of
on user's PC)?

Regards

Jeff

"Douglas J. Steele" wrote in message
...
Yes, the FE on the user's hard drive should mean you don't need a copy on
the network.

I have seen situations, though, where for whatever reason there will be a
separate FE on the network for each user. In other words, you'd have
FEJeff.MDB, FESkippy.MDB and FEDoug.MDB, potentially all in the same

folder
on the network. Why? I have no idea: I suppose they thought it was

necessary
to ensure that the FEs were backed up regularly. (And I suppose that

should
the users have the ability to add, say, reports to their FE, there may be
some merit in that decision).

And where we work, we're told we shouldn't store anything on our C:
drive,
so I know lots of people who put their front-end on the network.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
Hmmm? I had the impression that a FE on the user's PC obviated the
need
to put one on the network... (well, except in "escrow" for the updating
part ...)

Regards

Jeff Boyce
Microsoft Office/Access MVP


"Douglas J. Steele" wrote in
message
...
No, I think he did mean FE. You need to do this, for instance, with
Citrix.

While you'd still get issues with unnecessary network traffic, at
least
you wouldn't have contention issues.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Jeff Boyce" wrote in message
...
Uhm, Tony, did you mean "You could put the BE on the server as long
as
..."?

Jeff

"Tony Toews [MVP]" wrote in message
...

You could put the FE on the server so long as each user had their
own
copy of the FE. However this isn't as efficient as putting a copy

on
each users local hard drive.










  #12  
Old June 1st, 2008, 01:32 AM posted to microsoft.public.access.tablesdbdesign
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default FE/BE question

"Jeff Boyce" wrote:

Uhm, Tony, did you mean "You could put the BE on the server as long as ..."?


Nope. I meant FE.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #13  
Old June 1st, 2008, 01:34 AM posted to microsoft.public.access.tablesdbdesign
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default FE/BE question

"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote:

Have you noticed any (serious) performance issues with FE-on-LAN (instead of
on user's PC)?


We never noticed a problem on the Citrix servers at our client. I
might've been a bit more sluggish but who knows.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #14  
Old June 1st, 2008, 01:35 AM posted to microsoft.public.access.tablesdbdesign
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default FE/BE question

"Douglas J. Steele" wrote:

No, I think he did mean FE. You need to do this, for instance, with Citrix.


At the one client the IT department wasn't willing to setup a special
folder for the FE on the servers so we had to use the server. And I
can sorta see their point. Well, maybe.

Performance was acceptable so I didn't push the issue.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.