Re: remote access in 2002

#1

Would not advise them updating data over the net (dial-up/cable, etc) as
a general practice.
NEVER using DIAL-UP.
I occassionly update data with cable/RoadRunner as it has only gone down
once in 3 years. But depends on your local service.
Be warned: If there is any sort of hiccup on the network lines (or if
the network is in any way unstable) while they are updating, the data
tables are corrupted beyond repair.

They can safely READ over the net (slow).
Or your choices are:
1. create a web-based application (new forms) and put it on the web.
or
2. replicate the BACK-END. (and provide them with a copy of the
frontend.) assuming you've split the db into front-end (everything but
the tables) and back-end (data tables).
or
3. or change to more robust DB app such as Oracle/SQL for the backend at
least.

fldmark (AT) aol (DOT) com wrote:

Quote:

Hi
Could someone advise the best way to remotely access a MS Access 2002
database. I have the database and created all the user forms etc. The
position is that I have a sales office in one site (main site) and
also a second sales office in another town. Does Access allow the
remote access, maintenance of the database and are all the forms that
I have created on the database of no use when trying remote access.
Will I have to replicate the user entry forms with some ASP for
example.

Your advice would be much appreciated.

Mark

#2

Hi,
try RDB at www.udaparts.com

Yuancai (Charlie) Ye
RDB, a tool for fast and securely accessing remote databases with
dial-up, cable, DSL and wireless modems

Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, non-blocking and parallel computation

See 30 well-tested and real OLEDB examples
www.udaparts.com

parn <parn (AT) san (DOT) rr.com> wrote

Quote:

Would not advise them updating data over the net (dial-up/cable, etc) as
a general practice.
NEVER using DIAL-UP.
I occassionly update data with cable/RoadRunner as it has only gone down
once in 3 years. But depends on your local service.
Be warned: If there is any sort of hiccup on the network lines (or if
the network is in any way unstable) while they are updating, the data
tables are corrupted beyond repair.

They can safely READ over the net (slow).
Or your choices are:
1. create a web-based application (new forms) and put it on the web.
or
2. replicate the BACK-END. (and provide them with a copy of the
frontend.) assuming you've split the db into front-end (everything but
the tables) and back-end (data tables).
or
3. or change to more robust DB app such as Oracle/SQL for the backend at
least.

fldmark (AT) aol (DOT) com wrote:

Hi
Could someone advise the best way to remotely access a MS Access 2002
database. I have the database and created all the user forms etc. The
position is that I have a sales office in one site (main site) and
also a second sales office in another town. Does Access allow the
remote access, maintenance of the database and are all the forms that
I have created on the database of no use when trying remote access.
Will I have to replicate the user entry forms with some ASP for
example.

Your advice would be much appreciated.

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: remote access in 2002

comp.database.ms-access comp.database.ms-access

Re: remote access in 2002 - 06-27-2003 , 03:27 PM

Re: remote access in 2002 - 06-30-2003 , 08:46 AM