View Single Post
  #6  
Old June 4th, 2010, 06:45 PM posted to microsoft.public.access
David W. Fenton
external usenet poster
 
Posts: 3,373
Default Access as a Front-End

=?Utf-8?B?UUI=?= wrote in
:

I was lead to believe that the issue with access problem with
interruption was related to JET and that by 'switching' it could
be 'fixed' (poor on the terminology I am just looking into the
matter). Is this true? Is there another option rather than JET?
Or is it just as sensitive to network interuptions?

In this case, terminal services and CITRIX are both noth an
option.


Well, switching to a server back end *will* protect you from data
corruptions due to dropped WiFi connections.

But Arvin's point is that there is no guarantee of no corruption at
all, even with server-based database engines.

The advantage of a Terminal Server/Citrix solution is that you don't
have to alter your application at all for it to work, whereas
upsizing to a SQL Server or MySQL back end requires a lot of testing
and some degree of revision to work efficiently (substantially more
for a WAN/WiFi connection than it would on a LAN, where it often
requires very little change).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/