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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

replicating action queries in sql server 1
Using GUID in a query 8
Append query 3
Access Replication 14
Retrieve 2
Last auto-generated replication-id 6
Changing queries by code 1
Scaling results in data truncation 2

Back
Top