[AccessD] Access at a distance

Hi John

Then find a WinXP box and install:

http://www.thinsoftinc.com/product_thin_client_winconnect_server_xp.aspx 

Piece of cake to set up. Minimum license count is 3 and max. is 21- should fit nicely.
And license handling is much easier than the crazy system for Terminal Server.

/gustav

>>> John.Clark at niagaracounty.com 10-05-2007 18:02 >>>
It not my program...I didn't write it. It was written by the state...actually a contractor working w/the state...and there is an actual client install that we have to do. So I don't think altering it at all is an option. 



>>> Jim Lawrence <accessd at shaw.ca> 5/10/2007 11:15 AM >>>
Hi John:

Have you looked into synchronization/replication? The method can be setup to
either go automatically or once or twice a day.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Clark
Sent: Thursday, May 10, 2007 7:10 AM
To: 'AccessD'
Subject: [AccessD] Access at a distance

I've got a question, which I've never had answered satisfactorily. Does
Access pull the entire DB over a line, when accessed remotely, or does it
just pull a sub-set of the date, as requested by a query?

The reason I am asking is that we have an Access DB, designed by the state,
that is currently being used in a Niagara Falls department. They have
another office in Lockport, which is about 20-25 miles, to the East, and
they just asked that we install this program (the client) on two PCs in the
Lockport office.

I think that it is going to run dog slow, because whenever I've tried to run
a few programs I have up there, from my desk...also in Lockport...it is very
slow. I don't mind so much, because I am usually just checking things out,
or troubleshooting something, but if I have to do anything major, I copy it
down to my PC to do the work, and then load it back up.

My boss seems to think it is fine. He said, at his former company they ran
an Access app between Niagara Falls and Dallas, and it was slow but doable.
He said an operation that ran in 2 sec., would now take about 20 sec.. This
is fine for someone like me, to do something once in a while, but a data
entry person will go nuts w/these times.

So, basically I am looking for some definitive information regarding this,
so that I can make a better decision about going ahead w/this.

Thank you!

John W Clark