Re: Porting Access DB to a Web Application

"David-W-Fenton" wrote in message news:Xns9F0EA19C2E158f99a49ed1d0c49c5bbb2@xxxxxxxxxxxxxxxx

Actually, nearly everyone I every looked at allows remote.

Dotster here starts at $5.75 per month, and includes remote
database use. http://www.dotster.com/hosting/linux.php

The feature there is described as "Allows database management by
connection of a database client to a remote server." That doesn't
exactly sound like what is needed to support multiple users.

Well, it may not sound like, but it is in fact what it does and I been doing this for about 5+ years now.

I can in fact confirm that indeed this allows multi-user odbc connections.

GoDaddy, starts at $4.75 per month, and includes remote database
use: http://www.godaddy.com/hosting/web-hosting.aspx?ci=9009

I don't see remote access offered there at all. The only thing that
is close is "Direct Database Access" which is described as "Allows
users direct access to their public MySQL via Database Manager Tools
such as MySQL Query Browser." That doesn't begin to describe remote
access for multiple clients.

Well, actually, yes, it does. They not state the "web manager" tools, but in fact you use the client tools. These tools (be the SQL Visual studio, or MySql tools allow remote use and they connect via odbc).

Thus they allow the client tools to manage the database. It simply means that remote connections to the database server ARE allowed outside of the web site. This means MS Access can also connect.

It is a breeze to find hosting that allows remote connections to
the database server.

Really? I'm not sure you've identified even two, based on your
examples above.

They based on first hand experience. not even a question identifitying an example.

And even if the first one actually allows remote
connections, I wonder how safe it is, and if it's within the terms
of service to allow multiple client users to use that service.

Well, that is a fair question. I mean, clearly the external connection would be use for maintains, but ALSO pulling down data that been gathered into web forms. This also means simply using MS Access to use and pull that data. Opening and viewing tables in the client tools, or in MS makes no difference to the server.


In fact, EVEN among the low cost cheap-o hosting, half or
even more offer remote database connections.

If they are offering what the two examples show, I think that's
nothing more than remote management capability. Whether or not they
support multiple remote clients is an open question not resolved by
the information you provided.

The information I provided is that I stated I have been doing this for years.

However, yes, at the end of the day, the hosting does not really care what client tools you use. The need to pull data out, or push up data up to the server is a obvious requirement. Else, how can one get data in, or out of the system?

And in most cases, the windows
hosting package is about $1 more than the Linux one. The above are
in the $5 range, I did not check the more expesive higher pacakges
in the $10 to $15 range.

In a nutshell:

Remote database connections are easy to find, low cost, and very
common

This assertion is completely unproven at this point.

Only to you, been doing the above for about 5 years now...


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal@xxxxxxx

.

Relevant Pages

  • RE: VBScript: Remote Desktop Disconnected
    ... The client could not connect to the remote computer. ... Remote connections ... Re-running CEICW on SBS server: ...
    (microsoft.public.windows.server.sbs)
  • Re: /remote desktop control suddenly broken - critical
    ... The client computer may not be turned on. ... Remote Desktop connections may not be enabled on the client ... Verify that Remote Desktop is enabled on the computer you are ... connection from another computer on the Windows Small Business Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: Remote Web Workspace
    ... ALL client machines have RD turned on. ... > I have rerun the CEICW and the Netgear router is allowing connections on ... > I CAN logon to RWW, and CAN access Remote Outlook, CAN access Server ...
    (microsoft.public.windows.server.sbs)
  • RE: RDP Client Error message only on single computer.
    ... This can help us to narrow down whether this is a Windows XP client ... Check if Remote Desktop is turned on. ... When DFS is disabled on a Windows XP SP2-based computer, the Remote Desktop ... Remote connections ...
    (microsoft.public.windowsxp.general)