Security Issue

[IgorB]

Hi everybody,

What is the best way to prevent importing objects from another database
using File-->Get External Data-->Import?

Seems to me that if database does not have password , anybody can use the above feature and view data or source code!!!

Thanks

 

[ghudson]

You need to use Access security with user groups and permissions. Search the forum for Security or System.mdw or Workgroups for more info. Just remember to make backup copies throughout the process just incase you lock yourself out of your db. Good luck!

 

[IgorB]

What if the database is public and sharable without any difference between users?
Is this still good idea to secure db using group and permissions?

 

[ghudson]

What is the best way to prevent importing objects from another database
using File-->Get External Data-->Import?

Seems to me that if database does not have password , anybody can use the above feature and view data or source code!!!

You will need to secure your db if you want to prevent anybody from importing [linking] your db objects [forms, modules, tables, (data) etc.] into another db. The open database password is too easy [open freeware] to break but Access security will cost $$$ if somebody really wants to crack your workgroup info. If you are designing the db for multiuser access then you should split it, secure it and protect it so that the users can only access the data through a form and do not allow them open access to the db objects [tables, design view of forms, database window, etc.].