By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,341 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,341 IT Pros & Developers. It's quick & easy.

Stop users linking tables

P: n/a
Hi,

I want to Stop users to import my tables and queries into their database.
Is there some VB code or is only solution to make security workgroup
permission.
If this is the only solution please help me to create that file.

But I would be much appreciated with first solution.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ANSWER wrote:
Hi,

I want to Stop users to import my tables and queries into their
database. Is there some VB code or is only solution to make security
workgroup permission.
If this is the only solution please help me to create that file.

But I would be much appreciated with first solution.

Thanks


You can do numerous things to make it difficult for them to find your file
and/or the tables within, but the only real barrier is User-Level Security.
Even that can be broken if the person wishing to do so knows how to use a search
engine and is willing to spend a few dollars.

Bottom line is if the data *really* needs to be protected (from users) then it
doesn't belong in and MDB file.

Security is too broad and complex a topic to be given out in a newsgroup
posting. Google on "Access Security FAQ" and read as many links as you can and
then experiment on a dummy file. Only proceed on your real file when you have a
good handle on it.

My estimate is that 95% of the people who do security the first time do it wrong
and that 85% of those people never realize that they did it wrong.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.