Using the Internet to collect information from a remote MDB.

[doyapore]

Dear All,
I am in the process of developing an application in Access which would be
deployed in a remote region. The site has access to internet via Dial-up
Internet services.
My problem is that I have to collect and retrieve data from tables in that
particular MDB, via the internet, and update the tables in a central
repository. Is there a way to effectively solve the issue. The
central/master database [also an Access MDB] is located at a site which also
has Dial-up Internet services.
Can anyone please help me link up to a possible solution.
Your suggestions and advice are always highly appreciated and prized.
Thank you.

 

[Albert D. Kallal]

Could you not have the client email the mdb file after they have added data?
Then on your end, simply pull out the data from the mdb file?

or, are you in need of a system that is "on line", and that remote client
needs to up to date data all the time?

If you need a "on line" system, then I would reverse the model you have, and
keep the mdb file on YOUR system, and let them use the dial-up connection to
work on the file remotely. That way, you don't ever have to transfer the
data from their system to your system.

It really depends on the application, and what you are trying to do. Does
the client have a reliable internet connection?

You can read some of my thoughts are using ms-access in a wan type
environments here..
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[doyapore]

Thank you for your observations.
I am really looking at a reliable model which would enable me to access the
client-side data from a central location.
While the connection speeds are slow at both ends, they are reliable insofar
as they maintain their connectivity at all times without disconnection.

My plan of action is as follows:
1. Once the client PC is hooked onto the internet, it would send the central
MDB its IP address.
2. The central MDB would then latch onto the given IP address and form a
"tunnel" by which information (in the form of tables, text files, etc.) can
be ported from the central site to the remote client-side and vice-versa.

I am not sure whether its possible. But it was a thought.

 

[John Vinson]

Thank you for your observations.
I am really looking at a reliable model which would enable me to access the
client-side data from a central location.
While the connection speeds are slow at both ends, they are reliable insofar
as they maintain their connectivity at all times without disconnection.

My plan of action is as follows:
1. Once the client PC is hooked onto the internet, it would send the central
MDB its IP address.
2. The central MDB would then latch onto the given IP address and form a
"tunnel" by which information (in the form of tables, text files, etc.) can
be ported from the central site to the remote client-side and vice-versa.

I am not sure whether its possible. But it was a thought.

Just DON'T try to use an Access frontend - Access backend connection
using this scenario.

You're much better off using a terminal-server setup such as Citrix.

John W. Vinson[MVP]