remote operation via DSL connection??

[Markus Frey]

Hello dear ACCESS-users,

my problem is, that I want to operate an MS ACESS database with connected
tables
to a second MS ACESS database via a DSL (flat-rate) connection, but the data
transfer
via DSL between these two databases makes the operation very slow.
Maybe someone can give me an idea, how the data transfer to connected tables
in MS ACCESS
works, an how I can apply some optimations in order to make the operation
faster.

Maybe, there are some other ideas or possibilities to proceed a remote
access between to
MS ACCESS databases????

Thanks very much for every contribution or idea!

Mark

 

[John Vinson]

Hello dear ACCESS-users,

my problem is, that I want to operate an MS ACESS database with connected
tables
to a second MS ACESS database via a DSL (flat-rate) connection, but the data
transfer
via DSL between these two databases makes the operation very slow.

It also vastly increases the risk of database corruption. A momentary
line-noise or connection loss during an update operation can
irreversibly corrupt the entire backend database.

Maybe someone can give me an idea, how the data transfer to connected tables
in MS ACCESS
works, an how I can apply some optimations in order to make the operation
faster.

IME you simply can't do it this way, not reliably or with acceptable
performance. I lost a good client when they went ahead and implemented
a database over a WAN, over my objections.

Maybe, there are some other ideas or possibilities to proceed a remote
access between to
MS ACCESS databases????

Consider using Citrix or Terminal Server; keep the database (front and
back ends) on the server, and just use the WAN/DSL connection as a
link from the terminal client on the user's end.

 

[Albert D. Kallal]

You can read my thoughts on using a wan with ms-access.

Using a wan with ms-access? How fast, how far?
By Albert D. Kallal
Saturday, August 09, 2003

Using a wan with ms-access. - a instant network primer.

http://www.attcanada.net/~kallal.msn/Wan/Wans.html

 

[John Vinson]

You can read my thoughts on using a wan with ms-access.

Using a wan with ms-access? How fast, how far?
By Albert D. Kallal
Saturday, August 09, 2003

Using a wan with ms-access. - a instant network primer.

http://www.attcanada.net/~kallal.msn/Wan/Wans.html

Wow. Outstanding article, Albert... bookmarked for future reference!
Good to hear that the conclusions from my very limited experience are
borne out in this much more thorough analysis.