Can two developers use Access at the same time?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top