Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
security of database: a small doubt
- Thread starter proggy
- Start date
LittleSmudge
Programmer
Have you assisned the users ( yourself being one of them presumably ) to the correct Groups that have the appropriate rights to be able to see the tables , forms, etc in the database?
G LS
G LS
- Thread starter
- #4
- Thread starter
- #5
I am not joining the workgroup. I am just opening it ...
What is the 'it' you are referring to? Are you opening the workgroup or the database.
If all you are doing is opening the database, you need to either 'join' the workgroup (a .mdw file) or include the workgroup file with a switch as part of the shortcut that opens the file.
You will find directions on how to accomplish this in Access help by searching for the keyword 'workgroup'. - - - -
Bry
What is the 'it' you are referring to? Are you opening the workgroup or the database.
If all you are doing is opening the database, you need to either 'join' the workgroup (a .mdw file) or include the workgroup file with a switch as part of the shortcut that opens the file.
You will find directions on how to accomplish this in Access help by searching for the keyword 'workgroup'. - - - -
Bry
LittleSmudge
Programmer
I think you need to get the Access Security model clear in your mind.
You cannot possibly be opening the database without logging on in some way. You cannot "JUST OPEN IT"
What is happening is that the "Admin" username has not had a password assigned to it. ( This is the default situation with any databse before you start fiddling with User/Group security ) If this is the case then Access will always log you on automatically as the user name "Admin".
So if you have not placed the "Admin" user into any of the Groups that you have created and if you have locked down the "Users" group to be able to do nothing much at all ( like you should ) then there is the source of your apparent problems.
In order to be given the opportunity to log in as a specific username you must assign the "Admin" username a non-blank password.
'ope-that-'elps
G LS
You cannot possibly be opening the database without logging on in some way. You cannot "JUST OPEN IT"
What is happening is that the "Admin" username has not had a password assigned to it. ( This is the default situation with any databse before you start fiddling with User/Group security ) If this is the case then Access will always log you on automatically as the user name "Admin".
So if you have not placed the "Admin" user into any of the Groups that you have created and if you have locked down the "Users" group to be able to do nothing much at all ( like you should ) then there is the source of your apparent problems.
In order to be given the opportunity to log in as a specific username you must assign the "Admin" username a non-blank password.
'ope-that-'elps
G LS
- Status
Similar threads
- Locked
- Question
- Locked
- Question
