MS Access databse is just a file, which can be moved to any destination. There is no way to protect it from moving/copying to another folder on the VBA level. You can secure this file from opening/editing by doing several things...
10 tips for securing a Microsoft Access database[
^]
Description of how to help protect a Microsoft Access database [
^]
Personally, when i've been a MS Access database developer, i've been doing most of above recommendations and additionally a client - server model. How?
Client requirements:
- secured by custom authentication form,
- no tables (even linked tables),
- all forms, macros, etc.,
- path to the server database is saved in
custom property[
^].
Server requirements:
- all tables, queries
- secured by password
User opens a client database and must authenticate by passing login and password. Client reads connection string from custom property and connects required tables on demand...