how I add an username + posword to a mdb file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a homework to do and I don't want no body to open my file just my
teacher so how I create a login + password when I double click the .mdb file?

Thanks
 
Hi,
the easiest method in your case would be to assign a database password.
This would not require a user login, but rather only a password.
HTH
Good luck
 
I need a login and a password i know a password only but I need both
thanks for the information
 
Well there are two options. You can create some form of custom security,
meaning that you have a table with usernames and the associated
passwords...then you create a login form which uses a dlookup function to
check the provided values to the values in your table...if they match then
open the rest up...if not then close the application. Of course this sort of
security is not very hard to pass by. The other option would be to use the
build in ULS (user level security). It can be fairly confusing and
complicated so I would strongly suggest you read up on it before trying to
assing it.
Some good references can be found at Conrad's recourse site:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html#Security
You would also need to provide the created mdw file (workgroup file) to your
teacher for him to be able to open the mdb file.
HTH
Good luck
 
Back
Top