Re: no idea how to proceed

PCAnywhere is acceptable, if somewhat sluggish response depending on
your connection method. VPN connection is not recommended. Opening the
Access database over a remote connection will likely lead to
corruption of your database.

IIRC, PCAnywhere allows you to designate your locally-connected
printer as the printer for your host computer.

In a file server system, the server acts like a remote hard disk, and
all the computing power is handled by the computer that you are
sitting at. All the "guts" of the database analysis pass over the
network in "raw" format. In a client server system, there is an active
component on the server that connects to the database. Your local
computer sends requests to that active component on the server, which
acts upon the request, and sends the results back to the client. Only
requests and results pass over the network.

In a file-server system, users have direct access to the file system,
and can copy the database to their own computer, and play with it
outside your desired environment. In a client server system, they are
prevented from having direct access to the database files.

In a file-server system, a knowledgeable person could take your Access
database file, and hack away at it to their hearts content.

The security system in Jet/Access is strong enough to keep everyday
users from mucking with your database. It is not strong enough to keep
out a determined hacker.

On Mon, 26 Sep 2005 17:28:35 -0600, Josh <traygo@xxxxxxxxxxx> wrote:

>I was either going to use PcAnywhere, or a VPN connection. If PcAnywhere over
>the phone line, then performance will be throttled by being over phone.
>
>Possibly PcAnywhere (or remote desktop, or VNC) thru VPN/Internet DSL
>connection. Where they would be actually using a "local" computer.
>
>Since this all in the beginning stages, I'm not really sure what we're going to
>do. For instance, I'm not sure how they would be able to print a report if
>connecting to a "local" computer, etc.......I'm not even sure if they will need
>to print, or just to take a quick glance to see what the status is.
>
>Not sure what you mean by file/server vs client/server, can you elaborate on
>that a little?
>
>Thanks
>
>On 25 Sep 2005 21:50:31 -0700, "TC" <aatcbbtccctc@xxxxxxxxx> wrote:
>
>>How do you plan on letting the remote company access your db? You do
>>realize that Access/Jet is a file/server database - not a client/server
>>one like SQL*Server - so its response time could be absolutely terrible
>>(perhaps completely unusable) over the internet?
>>
>>HTH,
>>TC

**********************
jackmacMACdonald@xxxxxxxxxxxxxx
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
.

Relevant Pages

  • Re: dialup connection experience
    ... win/xp workstation using built in dialup server feature, ... some drawback opposed to some other third-party connection methods ... had excelent experience with pcanywhere 4.5, it was extremely simple, ... In general - my experience with the built-in Remote Desktop (for Windows XP ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Access Database becoming corrupt
    ... broken remotely or they go home on LAN and the server needs restarting etc. ... HP switch, 1 gig connection to server, 100mb to clients. ... Hired vendor to create inventory and sales database in ms-access. ... Vendor said he lost remote connection to our system, ...
    (microsoft.public.windows.server.sbs)
  • RE: Problems in terminal services, suggestions anyone?
    ... If the TS & Fox Pro database are on the same network, connections are not being dropped and no other application is affected then the problem is almost certainly with your installation of Fox Pro, which Citrix won't help at all. ... and at both the remote offices with a VPN. ... lose their connection to the database. ...
    (microsoft.public.windows.terminal_services)
  • Re: remote connection not always available with PCAnywhere, XP
    ... I don't know what's happening with PCAnywhere, ... Have you considered trying Remote Desktop instead--to see whether it works ... > server for the business software is our PCanywhere host. ... > is that PCAnywhere is waiting to make a connection. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Multiple Simultaneous Sessions on Remote Desktop PC
    ... a plain VPN.. ... Although XP Pro supports only one incoming connection, ... Remote Networking Technology Support Site - ... >Because the solution is not based on a server database ...
    (microsoft.public.windowsxp.work_remotely)
Loading