Hi all,
I'm investigating a remote access solution for a client. Five employees need
to work from home on an Access 2K split db. It's all working well on the
LAN, but I wonder what is the best solution for remote access?
-I've read that VPN won't work due to speed and corruption issues.
-Terminal Services/Remote Desktop worked well during my tests on my XP
boxes, but wondering about security issues (sensitive data will be
transmitted), and issues with firewalls, routers and the like
-What about other products like pcAnywhere, or open source?
Ideas greatly appreciated!
D
9  1827 
I am using Citrix MetaFrameXP for the remote users (connected via WAN) to
use an A2K2 Front-End with MS-SQL2K Back-End and it seems to work reasonably
well.
In your case, you probably need to talk to your network people regarding
security / encryption / firewalls / etc ...
--
HTH
Van T. Dinh
"D" <da**********@h otmail.com> wrote in message
news:HoOzb.9685 $d35.4027@edtnp s84... Hi all,
I'm investigating a remote access solution for a client. Five employees
need to work from home on an Access 2K split db. It's all working well on the
LAN, but I wonder what is the best solution for remote access?
-I've read that VPN won't work due to speed and corruption issues.
-Terminal Services/Remote Desktop worked well during my tests on my XP
boxes, but wondering about security issues (sensitive data will be
transmitted), and issues with firewalls, routers and the like
-What about other products like pcAnywhere, or open source?
Ideas greatly appreciated!
D
D,
We've been running A2K front end / A2K backend on Windows2000 Terminal
Server for several months, as many as 15 users. There were some security
issues, and some Win2K issues ( see http://support.microsoft.com/default.aspx?kbid=818528 for example), but
right now the app seems very stable. Fast, even using dialup, if you follow
the suggestions at http://www.granite.ab.ca/access/performancefaq.htm.
pcAnywhere will drive you crazy.
John
"D" <da**********@h otmail.com> wrote in message
news:HoOzb.9685 $d35.4027@edtnp s84... Hi all,
I'm investigating a remote access solution for a client. Five employees
need to work from home on an Access 2K split db. It's all working well on the
LAN, but I wonder what is the best solution for remote access?
-I've read that VPN won't work due to speed and corruption issues.
-Terminal Services/Remote Desktop worked well during my tests on my XP
boxes, but wondering about security issues (sensitive data will be
transmitted), and issues with firewalls, routers and the like
-What about other products like pcAnywhere, or open source?
Ideas greatly appreciated!
D
Thanks, John, for the multi-user caveat, and for warning me off of
pcAnywhere (I cringed when my client suggested it). I am following the
performance guidelines (as should everyone), so it should be fast as you
say. What about firewalls, routers, etc, with TS? Any potential hurdles to
account for?
As always, many thanks to all who replied,
D
"John" <ja********@nom ailhere.net> wrote in message
news:c0Pzb.1030 3$d35.4788@edtn ps84... D,
We've been running A2K front end / A2K backend on Windows2000 Terminal
Server for several months, as many as 15 users. There were some security
issues, and some Win2K issues ( see
http://support.microsoft.com/default.aspx?kbid=818528 for example), but
right now the app seems very stable. Fast, even using dialup, if you
follow the suggestions at http://www.granite.ab.ca/access/performancefaq.htm.
pcAnywhere will drive you crazy.
John
"D" <da**********@h otmail.com> wrote in message
news:HoOzb.9685 $d35.4027@edtnp s84... Hi all,
I'm investigating a remote access solution for a client. Five employees
need to work from home on an Access 2K split db. It's all working well on the
LAN, but I wonder what is the best solution for remote access?
-I've read that VPN won't work due to speed and corruption issues.
-Terminal Services/Remote Desktop worked well during my tests on my XP
boxes, but wondering about security issues (sensitive data will be
transmitted), and issues with firewalls, routers and the like
-What about other products like pcAnywhere, or open source?
Ideas greatly appreciated!
D
D,
I'm not the hardware part of the equation, but I know that only one out of
about 55 users set up so far has been unable to connect first time, and I
don't know what the resolution was. Those without XP use the downloaded
Remote Desktop Connection client. We're just about to try our first Mac
user, should be interesting. Main hurdles have been printers - older
printers with parallel cable connections are definitely preferred by
Windows2000. We have had some luck substituting drivers (HP6 driver for an
HP1200, for example). Other stumble is the 256 color limit - if you have
embedded graphics in your app, they may show up looking very garish. If so,
try saving them as 256 color .bmp and then re-inserting them into your
forms/reports.
Good luck,
John
"D" <da**********@h otmail.com> wrote in message
news:FkQzb.1304 9$bC.12753@clgr ps13... Thanks, John, for the multi-user caveat, and for warning me off of
pcAnywhere (I cringed when my client suggested it). I am following the
performance guidelines (as should everyone), so it should be fast as you
say. What about firewalls, routers, etc, with TS? Any potential hurdles to
account for?
As always, many thanks to all who replied,
D
"John" <ja********@nom ailhere.net> wrote in message
news:c0Pzb.1030 3$d35.4788@edtn ps84... D,
We've been running A2K front end / A2K backend on Windows2000 Terminal
Server for several months, as many as 15 users. There were some
security issues, and some Win2K issues ( see
http://support.microsoft.com/default.aspx?kbid=818528 for example), but
right now the app seems very stable. Fast, even using dialup, if you
follow the suggestions at http://www.granite.ab.ca/access/performancefaq.htm.
pcAnywhere will drive you crazy.
John
"D" <da**********@h otmail.com> wrote in message
news:HoOzb.9685 $d35.4027@edtnp s84... Hi all,
I'm investigating a remote access solution for a client. Five
employees need to work from home on an Access 2K split db. It's all working well on
the LAN, but I wonder what is the best solution for remote access?
-I've read that VPN won't work due to speed and corruption issues.
-Terminal Services/Remote Desktop worked well during my tests on my XP
boxes, but wondering about security issues (sensitive data will be
transmitted), and issues with firewalls, routers and the like
-What about other products like pcAnywhere, or open source?
Ideas greatly appreciated!
D
Thanks for sharing, John. Indispensible info.
Good luck with the Mac.
D
"John" <ja********@nom ailhere.net> wrote in message
news:qh5Ab.1855 1$bC.11827@clgr ps13... D,
I'm not the hardware part of the equation, but I know that only one out of
about 55 users set up so far has been unable to connect first time, and I
don't know what the resolution was. Those without XP use the downloaded
Remote Desktop Connection client. We're just about to try our first Mac
user, should be interesting. Main hurdles have been printers - older
printers with parallel cable connections are definitely preferred by
Windows2000. We have had some luck substituting drivers (HP6 driver for
an HP1200, for example). Other stumble is the 256 color limit - if you have
embedded graphics in your app, they may show up looking very garish. If
so, try saving them as 256 color .bmp and then re-inserting them into your
forms/reports.
Good luck,
John
"D" <da**********@h otmail.com> wrote in message
news:FkQzb.1304 9$bC.12753@clgr ps13... Thanks, John, for the multi-user caveat, and for warning me off of
pcAnywhere (I cringed when my client suggested it). I am following the
performance guidelines (as should everyone), so it should be fast as you
say. What about firewalls, routers, etc, with TS? Any potential hurdles
to account for?
As always, many thanks to all who replied,
D
"John" <ja********@nom ailhere.net> wrote in message
news:c0Pzb.1030 3$d35.4788@edtn ps84... D,
We've been running A2K front end / A2K backend on Windows2000 Terminal
Server for several months, as many as 15 users. There were some
security issues, and some Win2K issues ( see
http://support.microsoft.com/default.aspx?kbid=818528 for example),
but right now the app seems very stable. Fast, even using dialup, if you
follow the suggestions at http://www.granite.ab.ca/access/performancefaq.htm.
pcAnywhere will drive you crazy.
John
"D" <da**********@h otmail.com> wrote in message
news:HoOzb.9685 $d35.4027@edtnp s84...
> Hi all,
>
> I'm investigating a remote access solution for a client. Five employees need
> to work from home on an Access 2K split db. It's all working well on the > LAN, but I wonder what is the best solution for remote access?
>
> -I've read that VPN won't work due to speed and corruption issues.
> -Terminal Services/Remote Desktop worked well during my tests on my
XP > boxes, but wondering about security issues (sensitive data will be
> transmitted), and issues with firewalls, routers and the like
> -What about other products like pcAnywhere, or open source?
>
> Ideas greatly appreciated!
>
> D
>
>
On Thu, 04 Dec 2003 23:00:24 GMT in comp.databases. ms-access, "John"
<ja********@nom ailhere.net> wrote: D,
We've been running A2K front end / A2K backend on Windows2000 Terminal
Server for several months, as many as 15 users. There were some security
issues, and some Win2K issues ( see
http://support.microsoft.com/default.aspx?kbid=818528 for example), but
right now the app seems very stable. Fast, even using dialup, if you follow
the suggestions at http://www.granite.ab.ca/access/performancefaq.htm.
pcAnywhere will drive you crazy.
John
What spec terminal server? (CPU/RAM/HDD) I may be having to build one
pretty soon for about that many users.
--
A)bort, R)etry, I)nfluence with large hammer.
Hi D,
Try using RemotePC (( http://www.ibackup.com/remote_access/). It is
fast, reliable and works behind most firewalls and proxy servers using
RemotePC communication servers.
It is very secure as the entire communication is encrypted using
128-bit CRY/SAL to ensure security during remote access.
Regards
S
Hi D,
Try using RemotePC (( http://www.ibackup.com/remote_access/). It is
fast, reliable and works behind most firewalls and proxy servers using
RemotePC communication servers.
It is very secure as the entire communication is encrypted using
128-bit CRY/SAL to ensure security during remote access.
Regards
S
Hi D,
RemotePC doesn't use 128-bit CRY/SAL, it uses 128-bit RC4/SSL to
ensure security during remote access.
Regards
Smith
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: steve |
last post by:
Hi,
I finally figured out the best way to synch local and remote script
folders, containing many php script files.
What I used to do before was try to ftp all the changed files, etc.
which was tedious and often broke. It was also very slow.
What I do now is to pkzip the folder up, ftp the pkzip’ed data to
remote, and then unzip it there, which recreates the directories and
files.
|
by: great_googley_moogley |
last post by:
Greetings,
I am in the process of installing a SQL database at a customer
location. I have determined that there are 3 ways to do this, and I
wanted to know which is the best of the 3.
1 Install From Script.
In this method I create the database and its objects in scripts that
are run via osql utility on the SQL server machine. For loading any
initial data that I need in the database I also run bcp commands.
|
by: DrUg13 |
last post by:
In java, this seems so easy. You need a new object
Object test = new Object() gives me exactly what I want.
could someone please help me understand the different ways to do the
same thing in C++. I find my self sometimes, trying
Object app = Object();
Object *app = Object();
Object app = new Object();
|
by: nzanella |
last post by:
Hello,
I am currently upgrading a database of products to include pictures to
be displayed online. I would like to know whether it would be best to
store the pictures themselves in a database as a BLOB or whether it
would be best to simply store the filename. What are the pros and
cons?
Thank you,
|
by: vijay |
last post by:
I have a server running, Server has a remotable obj and a form which is
displayed
When a invoke a remote method in server, the thread is not able to access
form in the same server name space
It is even not possible to access the static methods in the server name
space,
When i tried to print the static variables in the form and in the remote
method, i got separate copies of the static variables
But this is not the case with COM,
| | |
by: kiln |
last post by:
I am starting a project that may be suitable for vb.net, using windows
forms. I want a rich client, thus win forms vs web forms. Most users
will access the app data over a LAN, but some will be remote users,
accessing via vpn. I could use terminal services for this but am
thinking that an alternate technology like remoting or web servies could
be viable.
- Rich client
- N-Tier
- LAN & Internet clients (via VPN)
|
by: robert |
last post by:
Hello,
I want to put (incrementally) changed/new files from a big file tree
"directly,compressed and password-only-encrypted" to a remote backup
server incrementally via FTP,SFTP or DAV.... At best within a closed
algorithm inside Python without extra shell tools.
(The method should work with any protocol which allows somehow read,
write & seek to a remote file.)
On the server and the transmission line there should never be...
|
by: gengyue |
last post by:
Hi,
Refer to my previous post "Calling web serive from JSP", I found an article on msfn2.microsoft.com.
"Using the WebService behavior, it is not possible to call a remote method directly on a server that resides in a different domain from the server hosting the Web page. However, Web servers can communicate directly with other Web servers, even if they reside in different domains. Therefore, it is possible to use the Web server that is...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
