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

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" <(E-Mail Removed)> wrote in message
news:5BEED8F9-AE9E-4516-8F16-(E-Mail Removed)...
>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

QB;3742142 Wrote:
> I am wanting to use either MySQL or SQL Server as a back-end to a M
> 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 itsel
> to
> wireless connections but have been told it can be done if changes ar
> made...?
>
> Can someone give me a little guidance on the matter. Perhaps refer
> 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 hardwar
or software. Expect more. IT support Los Angeles and small busines
consulting offers premier small business computer consulting and manage
IT services paired with easy access to computer sales and orde
management via online computer stores and help centers.

============================
http://www.project-drive.net


--
sandypeter111

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" <(E-Mail Removed)> wrote in message
> news:5BEED8F9-AE9E-4516-8F16-(E-Mail Removed)...
> >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
>
>
> .
>

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in
news:(E-Mail Removed):

> 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/

=?Utf-8?B?UUI=?= <(E-Mail Removed)> wrote in
news:C5CC659A-82B1-43CC-B066-(E-Mail Removed):

> 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/

if you want to use wireless, then you cannot use Jet.. Don't listen to
these idiots around here making excuses

move to Access Data Projects and SQL Server

it's a great combination, it allows you to keep your existing
investment in forms / reports





On Jun 3, 4:43*pm, QB <Q...@discussions.microsoft.com> 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

WOW THAT IS ****ING PRECIOUS. You're saying that SQL Server doesn't
support TCP/IP?

re: SQL-Server won't corrupt, they will, and sometimes
much worse than Access.


On Jun 3, 6:51*pm, "Arvin Meyer [MVP]" <arv...@mvps.invalid> 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, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access
> Co-author: "Access 2010 Solutions", published by Wiley
>
> "QB" <Q...@discussions.microsoft.com> wrote in message
>
> news:5BEED8F9-AE9E-4516-8F16-(E-Mail Removed)...
>
>
>
> >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 agood
> > article or site that covers this subject to get me going in the right
> > direction.
>
> > Thank you,
>
> > QB- Hide quoted text -
>
> - Show quoted text -