I have a situation with front end and back end databases which require security because it contains medical data. Because these databases need to be used by more than one person it resides on a network with folder level access security which has a very slow speed for these users.
My thinking is to use replication.
I would like to create replicas of the back and front on the users machine (C drive) that is synchronized to the network file when it opens so they have the latest information and then synchronizes when they close it to have a central storage place for all the users. Because of the way our network is configured I would then like the data on the C drive to be deleted when they are not using the database to decrease the potential for breach.
I have looked through the posts and was not able to find one that answered my question.
I have gotten as far as creating the secured replicas of both the front and back ends and they do sync individually but need to get the front end to sync the back end as the user begins to use the database (using the jrSyncImport option or the blank database on the users machine will wipe the master-I think)
The code I have tried (both attached to the autoexec file and the open_form of the initial menu) is:
Dim rep as JRO.Replica
Set rep = New JRO.Replica
rep.ActiveConnection = "C:\apps\...mdb"
rep.Synchronize "S:\scproj3\....mdb", jrSyncTypeImport, jrSyncModeDirect
set rep = Nothing
Get the infamous talk to the administrator you don't have permission error.
My thinking is to use replication.
I would like to create replicas of the back and front on the users machine (C drive) that is synchronized to the network file when it opens so they have the latest information and then synchronizes when they close it to have a central storage place for all the users. Because of the way our network is configured I would then like the data on the C drive to be deleted when they are not using the database to decrease the potential for breach.
I have looked through the posts and was not able to find one that answered my question.
I have gotten as far as creating the secured replicas of both the front and back ends and they do sync individually but need to get the front end to sync the back end as the user begins to use the database (using the jrSyncImport option or the blank database on the users machine will wipe the master-I think)
The code I have tried (both attached to the autoexec file and the open_form of the initial menu) is:
Dim rep as JRO.Replica
Set rep = New JRO.Replica
rep.ActiveConnection = "C:\apps\...mdb"
rep.Synchronize "S:\scproj3\....mdb", jrSyncTypeImport, jrSyncModeDirect
set rep = Nothing
Get the infamous talk to the administrator you don't have permission error.
