Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2012

    Angry Unanswered: update Access software not data

    I have created a small, 5-table Access database for a community center; 10-15 forms and queries, 2 reports, 5 tables. I want to deliver updates to the forms, queries, and reports, BUT NOT THE TABLES, now that i have delivered the software to the user. If i try to save off the tables, update the whole database, then copy the tables back, Access won't let me due to the relationships that I established. how can i do this?

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    Use a back-end/front-end schema: the tables (and only the tables) are stored in the BE while everything else (queries, forms, macros, reports, modules) is stored in the FE. You can deliver a new FE without altering the BE. You can use an assistant to split the existing database.
    Have a nice day!

Posting Permissions

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