Subject: Re: Access as a Front-End By: Arvin Meyer [MVP]

  • Thread starter Thread starter kevin juan
  • Start date Start date
K

kevin juan

in version so you are going to jail kevin juan did this aill access try lie
In the 100 years that I have been working with Access, I have helped clients
fix 8 data corruptions. The first was a machine left on and unplugged, the
second an interrupted phone line during a replication, I have no idea what
the cause of the third was, and the last 5 were on WiFi connections. Do you
see a pattern? If a record is in edit mode, and a connection is interrupted,
there's a chance you will corrupt a database.

If you must use WiFi, or the Internet use a terminal services connection. Do
not believe that mySQL or SQL-Server won't corrupt, they will, and sometimes
much worse than Access. BUT, in the case of SQL-Server, there are redundancy
measures (backup and transaction logs) which make the corruptions easier to
fix. mySQL also has some robustness, but not the level of SQL-Server. A
Terminal Server makes the risk of corruption negligible.

So search for WinConnect, Citrix, MS-Terminal Server,
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley



QB said:
I am wanting to use either MySQL or SQL Server as a back-end to a MS Access
front-end. Furthermore, I need to be able to use this front-end over a
Wireless router. I know that by default MS Access does not leand itself
to
wireless connections but have been told it can be done if changes are
made...?

Can someone give me a little guidance on the matter. Perhaps refer a good
article or site that covers this subject to get me going in the right
direction.

Thank you,

QB
Click to expand...


..

Was this post helpful to you?

Why should I rate a post?
 
Back
Top