silly question

[Guest]

I've been reading all this security stuff on how to secure a database and
have read about problems of the owner of the object, etc. If I'm
understanding this correctly, when they are talking about the owner and it
having irrevocable rights so you don't want it to be the Admin, are they
referring that a person who has Admin rights on the Windows operating system
should not create the database because then there would be no way to
completely secure it or are they referring to the Admin account in Access
that is the default log in when you open it??

If my understanding is correct, I created a database on our server, I'm not
an Admin user on our operating system, so it would have assigned my log in
info as the owner to the entire database correct?

Another thing, I've seen all the codes and such for disabling the shift key,
and the program that will disable and enable, if it's not secure. I've
already set up user-level security so I can't use that program unless I
import the data to another database. I've seen the other code but am unsure
of where to put it since I've seen put it in another database, intermediate
window, etc. Also, is that just a cut and past thing or do you need to
change variable (where), and can you use it if your database is secure?

 

[Jack MacDonald]

I've been reading all this security stuff on how to secure a database and
have read about problems of the owner of the object, etc. If I'm
understanding this correctly, when they are talking about the owner and it
having irrevocable rights so you don't want it to be the Admin, are they
referring that a person who has Admin rights on the Windows operating system
should not create the database because then there would be no way to
completely secure it or are they referring to the Admin account in Access
that is the default log in when you open it??

No - Admin is the default user in Access' userlevel security system.
It has no relation to the user account on your Windows OS, whether or
not that user has adminstration permissions on the computer.

I have a paper that may help with your understanding how security work
on the website in my signature.

If my understanding is correct, I created a database on our server, I'm not
an Admin user on our operating system, so it would have assigned my log in
info as the owner to the entire database correct?

Another thing, I've seen all the codes and such for disabling the shift key,
and the program that will disable and enable, if it's not secure. I've
already set up user-level security so I can't use that program unless I
import the data to another database. I've seen the other code but am unsure
of where to put it since I've seen put it in another database, intermediate
window, etc. Also, is that just a cut and past thing or do you need to
change variable (where), and can you use it if your database is secure?

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security