I thought my database was secure, but I didn't think about someone creating a new database and importing all of the tables, queries, forms reports and macros. Can I do something within my database to prevent others from importing or linking to my items?
-
-
I think a microsoft access workgroup prevents this?
If not, then you'd probably have to use a third-party solution. Maybe winzip and password protect it.
Or I suppose you could write an encoding algorithm into your database's code to encode all the data put into the tables so even if they link it they won't be able to understand it. -
The only thing I can think of to prevent user from relinking your tables is to apply Access workgroup security to your application, then use some simple "starter" application to start your Access application with command line switches /user ... and /pwd ...
This way, user doesn't have to now the password to start the application, thus cannot relink the tables.Comment
-
You could set a database password.
Tools / Security / Set Database Password...Comment
Comment