Using access via a network

[Andy Levy]

Hi - im not sure this is the right group for this post (if not - please
advise).

I have an access database with a frontend (mde) and Data-Backend (mdb). The
idea is that the backend will sit on a computer in one office - whilst the
frontends will be used on different computers in different offices
worldwide - accessing the backend. What is the best way to do this? Are
there any guides on the internet

 

[Art]

Hi Andy
Be warned: Going across WAN lines Access is a real
DOG! Be prepared to do some intense replication if your
users are worldwide. Depending on the situation, you might
even consider porting to SQL Server. Hope This Helps

The Easy Day

 

[Ron Weiner]

Andy

Even with fast internet connections I believe you are going to find that the
app does not perform very well. Remember with access all of your queries
are happening on the workstation running your front end. The back end is
just a data repository. Therefore if you run a query against a table with
1,000 records it is possible that ALL of those records will have to come
down the wire just to find the 10 or 20 you are interested in.

You should consider deploying your app using remote control software like MS
Terminal Srvices or Citrix.

Ron W

 

[TC]

Jumping in here:

There is >NO WAY< you can run the FEs remotely "world wide". Don't even
THINK about it.

Citrix, TS or similar may be feasible.

TC