I currently have a Access 2007 database on a network, in a protected folder.
I have a form built within it, which uses macros to "output" reports which are then made available to the users in a different networked folder (read only). The form is a simple one, containing 10 buttons, each with a macro to output a specific report to PDF in the reports folder. There is nothing else required on this form. We generate these reports infrequently, so they may or may not be entirely current with the database.
Is it possible to somehow, put a copy of the form that I use, in the read only folder with the rest of the reports (or on local drives), that would allow the users to run the form and generate a local copy of the latest information.
Obviously, I don't want users in the database folder, or anything but read access in the reports folder.
I have a form built within it, which uses macros to "output" reports which are then made available to the users in a different networked folder (read only). The form is a simple one, containing 10 buttons, each with a macro to output a specific report to PDF in the reports folder. There is nothing else required on this form. We generate these reports infrequently, so they may or may not be entirely current with the database.
Is it possible to somehow, put a copy of the form that I use, in the read only folder with the rest of the reports (or on local drives), that would allow the users to run the form and generate a local copy of the latest information.
Obviously, I don't want users in the database folder, or anything but read access in the reports folder.
