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
Show quoteHide quote

I need a login and a password i know a password only but I need both
thanks for the information

Show quoteHide quote

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
Show quoteHide quote

New Post - Owner deleted - No backups, nothing!
Problem with Multi-users in Access97
Suggestion on deploying and securing an Access appl
Security in fields
Preventing design changes with share-based security
Workgroup file in Network drive and Local computer
Creating a workgroup
Two DataBases, One Secure and One Not
Exclusive Access Message.........
Hiding database window