Background

Total Access Startup guarantees your users always launch the right version of Microsoft Access with the latest version of your Access database. Easily update each user’s database when the master copy is updated.

Split Database Architecture

The best way to support multiuser Microsoft Access applications is for each user to run their own copy of the Access application database. This split database architecture allows the front-end database to have private tables for each user and links to tables in a backend database or databases in Access, SQL Server or other formats. It also allows the developer to update the application and deploy it without having to update the data.

Question

How do you configure Total Access Startup to work in a Terminal Server (Remote Desktop or Remote App) environment?

Answer

 The Total Access Startup Administrator program lets you configure how your application is deployed. On the Launch tab, specify the Local Deployment and set the file name:

When you specify Local Deployment, rather than using an explicit folder name (e.g. C:\MyApp\...), use the special Path Variables so the database is installed in each user's private folder. This prevents users from running the same database.

Path Variables

Total Access Startup supports the following user-specific path variables to copy the master database to each user’s folder based on their Windows UserName:

%Profile%

e.g. type “%Profile%\MyFolder\MyDB.accdb” to copy to C:\Users\UserName\MyFolder\MyDB.accdb

%MyDocuments%

e.g. type “%MyDocuments%\MyDB.accdb” to copy to C:\Documents and Settings\UserName\My Documents\MyDB.mdb

%Desktop%

e.g. type “%Desktop%\MyDB.mdb” to copy to C:\Documents and Settings\UserName\Desktop\MyDB.accdb

See the help file or user manual for more information on the other options.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
•  PDF Fact Sheet