Updating data via an on line modem.

[Ricky1946]

Hello,
I have a customer who is requesting a facility to be able to update his Access application on his laptop via a modem on line to his main Access application tables on his server/hard drive at his office.
What would you advise is the best way to go about this?
Regards
Ian

"To say 'thankyou' encourages others."

 

[MoLaker]

Check out replication in Access Help. The details of how to connect to the server (which protocol, permissions etc.) would have to be resolved by the client's server admin. If the client's server has IIS, it could probably be done using Internet replication. But, if no IIS then look at "Briefcase" replication. This may require mapping a drive to the server, and Netbeui may be required as well.

 

[Ricky1946]

Thanks MoLaker.
Any other suggestions?

"To say 'thankyou' encourages others."

 

[payback]

What exactly is he trying to update? Programs? Data?

I am presuming that it is not just a link into the server he is requesting - this is usually solved by Terminal Server/Citrix etc.

 

[Ricky1946]

Hello payback,
It is necessary for his salesman/stock control person to access the stock levels on a daily basis from his laptop via a modem connected to the office's server or network. As the materials store is at a different location to the office he needs to make sure of the real-time stock levels are adequate at any time that he requires.
Is there an easy way to do this? The company does not have an IT department and I do not specialise in networking.
Regards
Ian

"To say 'thankyou' encourages others."

 

[payback]

Assuming that he will connect each time he wants to query the database (i.e. will not be downloading anything back to his laptop), there are a number of options. I am mainly experienced in software (with a little OS/hardware) and call in a network/hardware engineer whenever I can not solve something.

Our company uses a VPN within an internet browser (can be used either on dialup or cable/T1/DSL) to connect to the server using Terminal Server on an SBS2000 server (only one person generally connects therefore there is no issues about server load for us) but there are many options.You need to talk to an expert in these matters who can look at your own configuration and recommend solutions.

I am not sure if I can mention specific brand names, but to solve the issue when we can not find a local wireless access point, I found IPassConnect (through I2Roam) which offers worldwide connection if necessary.

BTY my name is Ian also.

 

[Ricky1946]

Thanks payback,
I have taken note of what you have said, but I think the best bet is to follow your lead and get in an expert.
Thanks for your help.

Regards
Ian
ps. All good people are called Ian!!!

"To say 'thankyou' encourages others."