Hello,

I am in the process of developing some access databases.  I have split
the database (The tables into a back end database and the code/forms
into a front end).  I liked the idea of being able to modifying my
forms anytime and then when complete, being able to copy the front end
database in place when no users are online.

The problem I have is, the users want to be able to share queries and
create custom queries.  What would be the best way to handle this
situation?  Since the users can create queries I can't just copy my
updated form back because they may have created queries while I was
doing development and that would result in lose of their new queries.

I thought about using replication of the development front end database
to the production front end database, but I would rather not use
replication if I don't have to.

Thank you for your inputs.