We currently have two developers that need to create queries and reports but,
in the same database. Can this be done, what would you suggest to work
around this?

Every version of Access since Access 2000 requires that you have exclusive
access to the database in order to save design changes.

Your database needs to be split into a front-end (containing the queries,
forms, reports, macros and modules) linked to a back-end (containing the
tables). Each developer should have his/her own copy of the front-end. As
long as you ensure they don't work on the same objects, once they're done,
import all of the new objects from one copy into the other.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Roberta" <(E-Mail Removed)> wrote in message
news:2E134870-4E68-43A5-8FCE-(E-Mail Removed)...
> We currently have two developers that need to create queries and reports
> but,
> in the same database. Can this be done, what would you suggest to work
> around this?