Encrypt tables without setting up groups and/or DB password

[DaOtH]

All,

I am trying to set up a secure database.
Currently, the shift key is disabled, and can be enabled when nessescary. Everything visible for the 'normal' user is the forms.

VB code is password protected.

Only thing i am trying to do right now is to avoid users import tables into a new database and so see what's behind the forms etc. Only thing i don't want is that users are supposed to log in etc.

I tried already database code/decode but that does not seem to do what i expect from it (which is what i state above)

Allidea's are welcome. "In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[ray00]

How did you disable the shift key? Where did you put the code? I need some help here! And also is there a way I can open the database window by clicking a button.

Thanks in advance.

 

[LittleSmudge]

<Thinking Out Load Mode>
You can Encrypt the database which will prevent someone linking to it or importing data to another database from it.
You can then ensure that the database window is hidden and a form opens when Access opens. You'll need to make sure that Access QUITS when the last form closes and make sure as ray00 says there is no chance of getting to a toolbar that can open the database window.
</TOLM>

Alternatively you can still use MSAccess security model and the users can get in without having to 'log in' if you ensure that the User password is blank.

 

[DaOtH]

I indeed tried to encrypt the database using tools-security-encrypt/decrypt database.

But when i do this and then create an empty database and try to import data from the would-be encrypted database it simply works.

Don't know what i am doing wrong here. &quot;In three words I can sum up everything I've learned about life: it goes on.&quot;
- Robert Frost 1874-1963