Deployment of Access Application - Roaming Users

bertusvanrooy

Registered User.
Local time
Today, 02:41
Joined
Jan 14, 2003
Messages
16
Hi to all,

I need some help on deploying my application in a mixed environment.

APPLICATION DETAILS:
I used MS-Office Developer XP to design the application. The file format is Access 2002 and I would like to use the packing wizard to install the application for users as they do not have Access installed on their computers.

My concerns are towards protecting the application, i.e. I would not like somebody to get hold of the design, VB source code etc. Secondly, I have to deploy the application in a mixed environment where some users are always on-line via the LAN and other are roaming Laptop users.

I have thought of using the Replication Manager that ships with Office XP Developer. The only problem is that I cannot rely on conventional replication due to the following:

1. The roaming users collect data that I want to be sent to the server DB when they log into the network back at the office. This data is contained in multiple tables in the DB. NB: I do not want them to receive data that was collected by other roaming users.

2. For the on-line users I would like some of them to be able to see all the data collected by the roaming users. The on-line users also maintain certain information on the server i.e. price lists etc. that I want to be sent to the roaming users when they log in to the network.

This is in a nutshell what i would like to achieve. Does anybody have any suggestions as to what the right approach would be.

Things i have thought about are Split DB's and Partial Replicas but maybe it's better to do via VB.

Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom