Queries in Replicated Database

  • Thread starter Thread starter CAMaslin
  • Start date Start date
C

CAMaslin

I have a database that is replicated. It has been working fine. I designed
5 new queries. When I right click and bring up the properties, the option to
make the queries replicable is no longer lit. I have not had any problem
before adn all other queries are replicable. What have I done that resulted
in these new queries not being replicable?
 
Realistically, the other ones shouldn't have been replicated.

Replication is only intended for data in tables, nothing else. Your
application should be split into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relationships). You can replicate the back-end, and simply give everyone
a new copy of the front-end.
 
Realistically, the other ones shouldn't have been replicated.

Replication is only intended for data in tables, nothing else.
Your application should be split into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing the tables and relationships). You can replicate the
back-end, and simply give everyone a new copy of the front-end.
Click to expand...

Queries are pure Jet objects, so can be safely replicated.

But the vast majority of your queries should be in the front end, of
course, not the back end, so your basic point is correct.

It sounds like the queries are being created in a replica, instead
of in the DM.
 
Back
Top