How to access a backend which is in remote place (Access 2003)

[MSK]

Hi,

I am not a newbie to Access, have developed couple of applications but
still dont know lot of concepts...

ok my question is

I have developed MS Access 2003 based application, where the
application has been split into Frontend (forms,queries,reports ) and
backend (tables) and these tables have been linked to the Frontend.

If I keep the backend in my local system D: drive and front end in C
drive - Its working fine
If I keep the backend in our company server SERVER-XYZ and front end
is in my local C drive - Its working fine since I could map the server
and link the tables.

But

I need to have the backend (Access 2003) file in London, and the
frontend (Access 2003) file in 2/3 different locations (e.g : Newport,
Manchester,Belfast...etc).

We have NTL network (internet provider)..now tell me how can I achive
this without any security issue, performance issue.

I dont know how to proceed, any small tips will be great !!! Any
sample code ? How to connect with the another server remotly ?...

Many Thanks.
MSK

 

[Stefan Hoffmann]

hi,

We have NTL network (internet provider)..now tell me how can I achive
this without any security issue, performance issue.

Your real problem will be the overall network through put. If it is high
enough, then you can simply setup an VPN between your sites.

If it is not high enough or latenecy is not stable, consider using a
Terminal Server. Then you FE and BE will be local to it, and only the
displays will be exported.


mfG
--> stefan <--

 

[aaron.kempf]

don't listen to that guy

you can't use MDB over a VPN it is ridiculously slow
move to Access Data Projects and SQL Server-- it works like a charm;
and it's a much much simpler architecture than Terminal Sessions.

I mean GET REAL

terminal sessions?
for MS Access?

ROFLMAO

 

[Albert D. Kallal]

Unfortunately to use a VPN as suggested will not work.

I explain your possible solutions here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

 

[MSK]

Thanks to everyone...