Automatic logon

[erb6572]

I am a beginner with access and am trying to use a database that someone else
set up. It is password protected, giving different levels of ability to
different people. The problem I am having is that my computer is
automatically logging me into the database. When this happens, I only have
"read-only" access to the database. My computer uses Access 2000. When I
log-on using a computer with an older version of Access, a login screen
appears, and I am able to enter my username and password, to gain access to
the database.

I have looked in all of the toolbars and properties menus, to try to find an
auto login feature, but have been unsuccessful. Is there something that is
making my computer automatically logon? How can I make the login screen
appear every time I open the database?

 

[Joan Wild]

I am a beginner with access and am trying to use a database that
someone else set up. It is password protected, giving different
levels of ability to different people. The problem I am having is
that my computer is automatically logging me into the database. When
this happens, I only have "read-only" access to the database. My
computer uses Access 2000. When I log-on using a computer with an
older version of Access, a login screen appears, and I am able to
enter my username and password, to gain access to the database.

Are you opening the mdb via a desktop shortcut or just by double-clicking on
the file? If the latter, it's likely you are using the default system.mdw
workgroup file, which logs you in silently as 'Admin'. In your database the
'Admin' user has read-only permissions. You need to create a desktop
shortcut to open the mdb. It's target would have the following in it.
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

If you are using a desktop shortcut, then check its properties. You'll
likely see /user "something" /pwd "something" in the target. That is how
you are getting logged in. You can delete this part of the target.

 

[erb6572]

Thanks for your reply.

Currently I open the database with a desktop shortcut, but it doesn't have
any of the things you mentioned in the path. The target is "F:\Database\CPAR
2000 RevA.mdb".

I have also tried to open the database from the actual file, and it does not
work. I will see about getting the "Admin" user to have full-control.

Thanks,
Elliott

 

[Joan Wild]

Thanks for your reply.

Currently I open the database with a desktop shortcut, but it doesn't
have any of the things you mentioned in the path. The target is
"F:\Database\CPAR 2000 RevA.mdb".

In that case you are joined by default to the required workgroup file. You
get no login because the Admin user doesn't have a password set.

Open the database and go to Tools, security, Accounts. Click on the Change
Password tab (you'll see you are logged in as Admin). Set a password for
this user. Close Access and reopen it. You'll get a prompt for
username/login. You can provide the username/login you wish.

I have also tried to open the database from the actual file, and it
does not work. I will see about getting the "Admin" user to have
full-control.

That would not be a good idea. The Admin user is common to all workgroup
files. It was likely setup this way on purpose - read-only for Admin. That
means that anyone that opens it using the standard system.mdw workgroup,
will get read-only access.

 

[erb6572]

I tried what you said and it worked to the point where I have the password
prompt. When I enter my user name and password it says that it is not valid.
When I go into the Accounts settings, the only thing there is Admin. If I go
to a computer with an older version of Access, and logon, and go to the
Accounts settings, there is a whole list of users and their permissions.
This database is older. Could it be a problem of compatibility issues from
one version to another?

 

[Joan Wild]

I tried what you said and it worked to the point where I have the
password prompt. When I enter my user name and password it says that
it is not valid. When I go into the Accounts settings, the only thing
there is Admin. If I go to a computer with an older version of
Access, and logon, and go to the Accounts settings, there is a whole
list of users and their permissions. This database is older. Could
it be a problem of compatibility issues from one version to another?

You are not using the correct workgroup file.

Go to the computer with the older version. Look at the shortcut - you'll
see the workgroup file that is being used; its path is after the /wrkgrp
switch.

You need to use that workgroup file on your computer. Usually it would be
placed on a network share where all have access to it.

Create a desktop shortcut on your computer with the target of
"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"

Ensure you get the pathnames correct, and you are using the right mdw. You
can use UNC pathnames if you like.

 

[ding]

Thanks for your reply.

Currently I open the database with a desktop shortcut, but it doesn't have
any of the things you mentioned in the path. The target is "F:\Database\CPAR
2000 RevA.mdb".

I have also tried to open the database from the actual file, and it does not
work. I will see about getting the "Admin" user to have full-control.

Thanks,
Elliott