Accessing an access database regionally

V

vbcraft

What is the best way to access an Access database application (been split to
FE / BE with wrkgrp file aswell) regionally. I know that shared drives are
very slow (actually i think) and i read a bit about Terminal server....just
not sure about all options that i can relay to my client.

Thanks in advance for any feedback!
 
B

Boyd Trimmell aka HiTechCoach via AccessMonster.co

You could use a WAN with a Access back end which is normally slow, unlike a
shared drive on a LAN which is fast.

You could use a WAN with a SQL server back end/ ADP front end which is
usually a lot faster the an Access backend.

Use remote access of some type. Terminal Server (I use it a lot) or Citrix,
or remote control a machine.

Hope this helps ...
 
V

vbcraft

Thanks for the quick reply and the info. I will look into these options ...
for now I want to stay away from converting the backend to SQL server.

You use Terminal server a lot and it works fine? I have never implemented
an access mde FE/BE this way. What do I need to have? I want to mention this
option to client. Is there any site I can get info about this. (re: setup,
requirements, using wrkgrp with TS etc...) sorry for all the questions.

Thanks again,
 
B

Boyd Trimmell aka HiTechCoach via AccessMonster.co

Normally there is nothing that needs to be change in your access database, if
it is already split, to run it in a Terminal Server.

see this
http://en.wikipedia.org/wiki/Terminal_Services

Thanks for the quick reply and the info. I will look into these options ...
for now I want to stay away from converting the backend to SQL server.

You use Terminal server a lot and it works fine? I have never implemented
an access mde FE/BE this way. What do I need to have? I want to mention this
option to client. Is there any site I can get info about this. (re: setup,
requirements, using wrkgrp with TS etc...) sorry for all the questions.

Thanks again,
You could use a WAN with a Access back end which is normally slow, unlike a
shared drive on a LAN which is fast.
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
B

Boyd Trimmell aka HiTechCoach via AccessMonster.co

Also check out:

http://www.msterminalservices.org/
Thanks for the quick reply and the info. I will look into these options ...
for now I want to stay away from converting the backend to SQL server.

You use Terminal server a lot and it works fine? I have never implemented
an access mde FE/BE this way. What do I need to have? I want to mention this
option to client. Is there any site I can get info about this. (re: setup,
requirements, using wrkgrp with TS etc...) sorry for all the questions.

Thanks again,
You could use a WAN with a Access back end which is normally slow, unlike a
shared drive on a LAN which is fast.
Click to expand...
[quoted text clipped - 13 lines]
Click to expand...
 
Top