Accessing an access database regionally

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vbcraft - 28 Nov 2007 21:48 GMT

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!

Signature

Thank you,
vbcraft

Reply to this Message

Boyd Trimmell aka HiTechCoach - 29 Nov 2007 06:17 GMT

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 ...

>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!

Signature

Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Reply to this Message

vbcraft - 29 Nov 2007 06:46 GMT

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,

Signature

Thank you,
vbcraft

> You could use a WAN with a Access back end which is normally slow, unlike a
> shared drive on a LAN which is fast.
[quoted text clipped - 13 lines]
> >
> >Thanks in advance for any feedback!

Reply to this Message

Boyd Trimmell aka HiTechCoach - 30 Nov 2007 04:12 GMT

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.
[quoted text clipped - 11 lines]
>> >
>> >Thanks in advance for any feedback!

Signature

Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Reply to this Message

Boyd Trimmell aka HiTechCoach - 30 Nov 2007 04:14 GMT

Also check out:

http://www.msterminalservices.org/

Signature

Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com

Reply to this Message