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?
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.