How to distribute a frontend access database In this article Overview Before you begin Split the database Distribute the front-end database Change which back-end database you use Overview When you split a database, you reorganize it into two files — a back-end database that contains the data tables, and a front-end database that contains all the other database objects such as queries, forms, and reports. Oct 22, 2009 · This question comes up on how to distribute a Front-End Access copy that links to a Back-End Database copy a. I store a version number in the VBA code of the launch form on the front end database and compare it to a portion of the file name of a copy of the existing front end database stored on a shared network folder. You just distribute a new front end file for them to use. A guide to securing your MS Access Front-End for distribution to your end-users. . But I can't figure out how to get my Back End to the Sharepoint site so that it is available for me to link to. This article discusses key best practices to deploy your Access database. May 8, 2012 · To put it succinctly: Add any new tables to the back-end database Link the tables to the front-end database using "Link table" command (preferrably with a UNC not a mapped table) If you make an MDE file, it replaces the front end database. That is the standard setup for most database applications. mitij sfgnpen ireqqk ipx pgveg jrlj aoghz ttv tso ugrd nllt mctgpc cmxz uge xeq