I have an issue with a replicated database where I take field data using the master database on my laptop then synchronize with the replica that is on our server at work and used by several others from the server. The problem seems to be that the references I set on my laptop do not seem to work the same on the server copy, so that if I use date() on a form in the conditional formatting of a control, it is no problem on my laptop, but not recognized as a function on the server copy. also in forms I have a text box with control source: =Right(Year(Now())-3,2) which on my laptop displays '07' but is not recognized on the server version. There are several issues like that and I cannot set references on the replica because I cannot save changes on that copy.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Synchronization problem 1
- Thread starter tbac
- Start date
-
1
- #2
The master should not have any forms, reports, or queries only tables. This is a bad design you are suggesting, and begging for some serious problems!
On the network you should have the master back end with only tables in it. Each user should have on their local machine a replicated back end with a replication of the tables and a front end that links to their back end tables. The users local front end has all forms, reports, code, and queries.
On the network you should have the master back end with only tables in it. Each user should have on their local machine a replicated back end with a replication of the tables and a front end that links to their back end tables. The users local front end has all forms, reports, code, and queries.
- Status
Similar threads
- Locked
- Question
- Locked
- Question