Access as a Front-End
in [General]
|
Prev: Helllooo
Next: Access2007 Combo Box
From: QB on 3 Jun 2010 19:43 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
From: Arvin Meyer [MVP] on 3 Jun 2010 21:51 In the 18 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" <QB(a)discussions.microsoft.com> wrote in message news:5BEED8F9-AE9E-4516-8F16-7D071D0BA2B8(a)microsoft.com... >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
From: sandypeter111 on 4 Jun 2010 02:41 QB;3742142 Wrote: > 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 The aim is to fix problems and all concerns as to who makes the hardware or software. Expect more. IT support Los Angeles and small business consulting offers premier small business computer consulting and managed IT services paired with easy access to computer sales and order management via online computer stores and help centers. ============================ http://www.project-drive.net/ -- sandypeter111
From: QB on 4 Jun 2010 08:26 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. Thank you for your input, it is greatly appreciated. QB "Arvin Meyer [MVP]" wrote: > In the 18 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" <QB(a)discussions.microsoft.com> wrote in message > news:5BEED8F9-AE9E-4516-8F16-7D071D0BA2B8(a)microsoft.com... > >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 > > > . >
From: David W. Fenton on 4 Jun 2010 13:42
"Arvin Meyer [MVP]" <arvinm(a)mvps.invalid> wrote in news:O1Btth4ALHA.3840(a)TK2MSFTNGP02.phx.gbl: > 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. In the replication case, had indirect replication been used instead of direct, the dropped call would not have corrupted anything at all. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |