to Jon moderator sorry i acceidentally posted this in the sql server section as well)
hi guys first of all thanks for taking the time to read my query :
I had a quick question regarding the replication issue.
I have managed to create the design master, and replicas, and replication works fine except for the fact that there
is one table called tbloptions that i dont want replicated, as a value in there corresponds to the store which the
program is run.
Naturally this cant be replicated as the value would then change which i dont want it to..
However i tried the following options to no avail :
* Creating a full replica then trying to disable the table from the replica - cant do
* Creating a full replica then disabling the table from the design master (right click on the table and unchecked
the replicable option) - on synchronisation this wipes the table completely from the replica.
* Creating a partial replica not including tbloptions then both trying to import the table from a copy of the database that hasnt been converted to design master by using 'get external data' and using the
make-table query in access to create a local copy of the replicated tbloptions.. the second method looked like it was going to work as the tbloptions had (local) next to it instead of (replicated)
However the VB program couldnt get read permissions on the tbloptions(in initial program execution)... i dont know why cause i can edit that table perfectly fine myself through access.
The other replicated tbloptions works fine in the program as well as the original access database..
so im at a loss and i dont know what else to try....any ideas?
Surely there must be a way in Access to have local and replicated data in the same database? Maybe ive just missed it.
Also the synchroniser seems to only work when it wants too, sometimes nothing happens when you right click the link between two computers (which have successfully synchronised before), does anyone know anything about this?
And this is after I have tested that the remote network directory that it is synchronising with is actually accessible. It is over dial up however and connection speeds dont even reach 33.6 most of the time either for some reason.
Ive checked the microsoft FAQ and yeh, very brief, as well as these boards to no avail
Thanks in advance for any advice given. (if anyone has been in this situation before) Its for 3 shops communicating sales data with the warehouse (access 2000, windows 2000 prof, access 2000 developer)
hi guys first of all thanks for taking the time to read my query :
I had a quick question regarding the replication issue.
I have managed to create the design master, and replicas, and replication works fine except for the fact that there
is one table called tbloptions that i dont want replicated, as a value in there corresponds to the store which the
program is run.
Naturally this cant be replicated as the value would then change which i dont want it to..
However i tried the following options to no avail :
* Creating a full replica then trying to disable the table from the replica - cant do
* Creating a full replica then disabling the table from the design master (right click on the table and unchecked
the replicable option) - on synchronisation this wipes the table completely from the replica.
* Creating a partial replica not including tbloptions then both trying to import the table from a copy of the database that hasnt been converted to design master by using 'get external data' and using the
make-table query in access to create a local copy of the replicated tbloptions.. the second method looked like it was going to work as the tbloptions had (local) next to it instead of (replicated)
However the VB program couldnt get read permissions on the tbloptions(in initial program execution)... i dont know why cause i can edit that table perfectly fine myself through access.
The other replicated tbloptions works fine in the program as well as the original access database..
so im at a loss and i dont know what else to try....any ideas?
Surely there must be a way in Access to have local and replicated data in the same database? Maybe ive just missed it.
Also the synchroniser seems to only work when it wants too, sometimes nothing happens when you right click the link between two computers (which have successfully synchronised before), does anyone know anything about this?
And this is after I have tested that the remote network directory that it is synchronising with is actually accessible. It is over dial up however and connection speeds dont even reach 33.6 most of the time either for some reason.
Ive checked the microsoft FAQ and yeh, very brief, as well as these boards to no avail
Thanks in advance for any advice given. (if anyone has been in this situation before) Its for 3 shops communicating sales data with the warehouse (access 2000, windows 2000 prof, access 2000 developer)
