Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Houston, Texas, USA
    Thanked 0 Times in 0 Posts

    Modifying objects in a shared database (Access 2003)

    Can you modify objects in a shared database while someone is in the database? For example, a person is editing a table and I want to change the table name or a field in a table while they're in it, can I do that? What about making changes to an object they are not working in, but in the same database? If so, is there a potential problem?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Modifying objects in a shared database (Access 2003)

    No, that is not possible in Access 2000 and later, for very good reasons. In Access 97, it was possible to edit database objects while others were working in the database too, but this could easily lead to conflicts and even database corruption. Therefore, you now need to open the database exclusively in order to change its design.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts