469,963 Members | 1,885 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

Hide a table through Code

Hello Everybody,
Im Trying to hide my tables so that they can't be imported/linked from another database.

i've searched, and searched, and i have a question that i haven't found already asked anywhere. I work for a corporation, and have self taught myself access, and VBA. we have a database where i work, and my manager would like to share our database with other groups. the only problem is that certain people aren't allowed to see some things, when other people are.

in some of my searching i have done out here i have found that even in a database that is locked out completely, you can still import all of the information by opening another database, and importing the data. i want to be able to write some kind of code that would hide the tables so that nobody is able to import that table from another database.

Does anybody have any ideas on what i would be able to do that would prevent a table from being imported, or linked from another database?

Thanks
Jul 18 '07 #1
0 841

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.