Access and Terminal Server

[smig]

One of my clients want to change his network into Terminal Server system.

1. How well will Access work with this new setup?
2. Will Access, and the specific App, be installed on each user machine?
3. Currently I'm using the registry to save some user's and App data. Can I still use the registry?
4. What about 3rd party DLLs that are installed with the app?

Thank you,
Tal

 

[pr2-eugin]

I have the same trouble, I have a Terminal Server and windows network setup. I have to deploy two versions (atleast for me because TS uses 64 bit). All the DLL's needs to be registered on the TS. The Access's backend should be placed in the Terminal server and your local system needs to connect to it using Mapped Network drive.

I am not sure about using App Data, however considering the fact, App Data is local to each user, they should still behave as normal. However I am not 100% sure about it.

 

[CJ_London]

One of my clients uses terminal server which I can connect to from my office (required a fixed IP address) for maintenance purposes.

They have it structured that both front end and backend are on the server - each user has their own user profiles etc in the same way as you would on a pc. - you will find performance is much faster

I distribute a front end to each user local apps folder with the back end in a globally shared directory - they do not need ms access on their personal PC, but do within terminal server - although you can set up to use runtime instead.

In the globally shared directory I have a small file which the user opens from a shortcut on their pc desktop which takes them through TS security. Note users do not have direct access to any of the directories, only shortcuts on their PC to each of the systems they have access to. However another client who uses TS allows their users full access to TS

The small file checks for db updates and if there are any, replaces the front end in the local app folder, then opens the front end.

Note the front end is accde

1. How well will Access work with this new setup? faster than working across a network - it's about the same as having the backend on your PC.
2. Will Access, and the specific App, be installed on each user machine? No
3. Currently I'm using the registry to save some user's and App data. Can I still use the registry? Possibly, not tried it, but there is a similar registry setup on TS
4. What about 3rd party DLLs that are installed with the app? You would copy to TS

Basically TS is like having multiple users using the same PC concurrently rather than contiguously

 

[smig]

Thank you for the info.
Its already installed on the machine that will be used as server.