Re: Database Split and Linked Table

It may be the best way to run a seperate copy of the FE on each individuals
computer but I have been running several DB's with both the FE & BE on the
main servers for a number of years without any major problems.

Interesting point. So did I on one smallish site "just for the hell of it" and
I had no major problems either. My thinking was "if I don't try it I don't
know!", also for a similar reason to Jeanette that the program was initially
changing quite often (in itself, a bad practise!<g>)

Nevertheless, there are very sound reasons for Doug's advice. All I can say is
that, certainly an FE can be run on a server, but it is "best" to run it on
each client PC. For example, it will run "faster" / in a given case however
it might very well be "fast enough" anyway. Though it's more likely that
developers want to do everything they can to improve speed, reliability, etc,
because those are often ("usually?")("nearly always?") major issues with
Access.

All of which just means, I agree it's "best" have separate FE's! Perhaps an
analogy might be, I s'pose my car might run for quite some considerable time
even if I don't give it the proper service! (I do, by the way) <forget
that-weird analogy>

Some procedures (such as situations which require temporary tables, an import
perhaps) will not work the same (or as easily or reliably) if everyone is
using the same FE.

It is NOT difficult (in my opinion) to keep separate FE's updated. Even before
Tony Toews' well-received updater (or anyway), I had version checking on
startup between FE and a version number held in the BE. That way, I could
force users to upgrade if their FE was "forgotten about", they restored from
an old backup, got hold of an older CD, whatever. All these things happen!
Besides, sometimes an upgrade to a product also includes changes to a BE,
making it incompatible with older FE's, and this is not too difficult to
handle with a reasonable scheme and separate FE's either. Sort it out once,
and you can use the same "proper" scheme for all subsequent programs you
write!


I can't really believe another comment of yours, Bob. I've installed software
on some reasonably large sites, and I tell THEM how my software installs not
vice versa. Separate FE's does not appear to me to be an issue which affects a
given corporations security policies or whatever, or in any case if their
policy conflicts with very sound Access advice. I am required to keep my
software running, and I can only do that if they take my advice (whatever it
may be <g>).

Chris


.

Relevant Pages

  • Re: Why are so many people using 4.x?
    ... I've never had to ask a question or had any issues when patching or installing software/hardware on my 4.X servers. ... If you want to *learn* FreeBSD I would recommend 4.X as there is lots of information, forum data, HowTo, example information already out there. ... Good reasons to recommend 6.X would be "bug FOO is fixed", "hardware FOO is now fully supported", "FOO is now a kernel module and can be unloaded or loaded at will", "disk performance is gazillion% better", etc. ... "Because it's new" is the reason I stopped using Linux. ...
    (freebsd-questions)
  • Re: Flamebait if I ever saw it
    ... just as Lisp and JavaScript do. ... The whole point of functional programming is to be able to reason about the parts of a program separately, in the same way that we can reason about separate mathematical functions separately. ... When you have mutable data in a *dynamic* language you can no longer do this - any function, anywhere in the program, can mutate not just the value of a datum, but it's *type* as well. ...
    (comp.lang.lisp)
  • Re: UML notation question...
    ... > is just fine for your first specification. ... there is no reason to separate them for reasons similar to ... > Class Models", which IMO is the best book available on practical OO ...
    (comp.object)
  • Re: Input Box selection and file open
    ... lines of data you showed actually on separate lines in the file itself? ... The reason I ask is because when I tried to run your ... >>> Rick you've obviously been working with idiots for too long because ... I repeated the Dim statements. ...
    (microsoft.public.excel.programming)
  • Re: Need to forward request for a domain to another DNS server
    ... > have several virtual machines running on my machine hosting several AD ... > environments, and for some reason, I need to restart or to change the DNS ... >>> Not the wrong servers ...
    (microsoft.public.win2000.dns)