MS Access - no copy

[Liquid Metal]

What is the best way to protect an MS Access database from being copied onto a usb drive or emailed home? The answer might be no possible ways but I still have to ask.

[jmcilhinney]

Access databases are just files, so this is a file system issue, not a database issue. How can you normally stop someone copying a file? Basically you can really only put it in a folder they don't have permission to access, but then how would your app access the database?

[Liquid Metal]

Basically you can really only put it in a folder they don't have permission to access, but then how would your app access the database?

That is the million dollar question which I kind of answer myself already too.

So, there is no connection string that can access a protected folder or any other trick that I might now know?

[jmcilhinney]

You can apply security measures to an Access database, like file and user passwords, that will prevent someone opening the file without authorisation, as long as they're not too determined. That won't stop people copying the file but they won't really be able to use the copy.

[Liquid Metal]

thanks jmcilhinney