How can I prevent users from importing tables in my access dbase?

[M. Zak]

I need users to be able to see and modify data only through the form I built
for that. Now if someone try to import data from my table how can I prevent
that. Making user groups is not that effective by the way

 

[Douglas J. Steele]

Applying Access User-Level Security (which I assume is what you mean by
"making user groups" is the only way.

What's not "that effective" about it?

 

[M. Zak]

OK, I need to allow data updating, in the "making groups" method if you allow
users to modify data in your database, they'll be able to import tables, let
me know if you have any questions.

 

[Douglas J. Steele]

Have you read the Access Security FAQ?
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

You can use RWOP queries, and not give the users any permissions on the
tables themselves.

 

[M. Zak]

if there is a "Visual Basic code" to make my DB open only through the form I
build for that, I would appreciate it. Startup properties could be changed by
any advanced user

 

[Douglas J. Steele]

Startup properties can't be changed if they're set properly.

See http://www.mvps.org/access/general/gen0040.htm at "The Access Web"

 

[M. Zak]

how you think the startup property shall be set? I can disallow all the
startup objects and allow only the form, what else I can do?

 

[Douglas J. Steele]

I'm sorry, I don't understand your question.

 

[M. Zak]

I mean how can I prevent users from bypassing the startup rules I'm going to
set? example; say I disallowed the db window view, and had a particular for
to be displayed at startup, still I can as a user bypass that rule and make
the startup to show the db window again...

 

[Douglas J. Steele]

How can you bypass the rule if you've set the AllowBypassKey property to
False?

If you didn't create the AllowBypassKey property as outlined in the article
I cited previously, then yes, a determined user could change its value back
to True, open the database with the shift key depressed and change the
startup rules, but if you created it properly, only an administrator would
be able to do that.

 

[M. Zak]

Now where I need to put the code that will creat the AllowByPassKey property?
in the form code builder or in a level higher than that? and the same
question for the code that will disable the AllowByPassKey property, I tryed
creating a separate module but didn't work...thanks for your help

 

[Douglas J. Steele]

You don't actually need to store it anywhere in your application.

Create a module (not a class module nor a module associated with a form or
report), copy the code from that page (what's between "Code Start" and "Code
End"), go to the Immediate Window (Ctrl-G), type

ChangePropertyDdl "AllowBypassKey", dbBoolean, True

and hit Enter. You can then discard the module without saving it.

Close the database, and you will no longer be able to use the Shift key to
bypass your startup rules.

 

[M. Zak]

thank you much, I tried it and it's working, except I had to add the value
"0" instead of "false"...
By the way, how can I allow bypass keys for my self and disallow for other
users? thanks agian and have a fantastic one

 

[Douglas J. Steele]

Oops, that should have been

ChangePropertyDdl "AllowBypassKey", dbBoolean, False

There's no way to allow the bypass key for some users but not for others.

 

[M. Zak]

No problem, thanks for your help I sure found it very useful..!!