I have been making an Access 200 db for the last 2.5 years and have just learned DAO(I have be using ADODB until now). I made a form with various combo, text, and check boxes on it to make a query based on the selections and open a report based on this query. The problem is that my db is replicated and it won't allow editting of the query in the replica. Does anyone know of a way around this? Thanks for your time.
You need a Design Master to change anything in a replicated DB.
If you don't have it you can convert from replica to a Design Master
from Tools > Replication > Recover Design Master.
(Don't allow two Design Masters )