Hello
I am new in setting up security on an MS-Access db and would like some
input. The options is to split the db - FrontEnd and BackEend mdb's.

There will be less than 7 people who will be utilizing the application and
most are located outside of U.S. office

The db is not very complex, the purpose is to keep a yearly list of
inventory and an audit trail of changes. For the reporting, there will be
several DAP's, so other users do not have to open MS-Access and run it on
their time and data will be dynamic. In addition, the number of tables <=20,
queries > 40, reports >= 20.

- Will there be issue with performance once the FE/BE gets implemented on a
WAN environment? The db on average will grow less than 100MB for the year.
The next year, we start another set of data.
- on the connection setting of my DAP reports, since it is going to be
stored on WAN environment, is there a way to programmatically change via vba
code? my concern, in case the BE gets moved into another location on the
shared drive of the network.
- is it recommended to create the MDE even if security is applied?

Thank you!
Bob