When you open Access you are opening a mdb file (a database). The security
settings are based on the workgroup file to which you are joined (mdw). You
are always joined to a workgroup file. You say that the user is filled in
and you are required to enter a password, what User is entered? If you try
to open any other database file, you should also be required to enter a
password. This is not being required by the database file, it is being
required by the workgroup file.
Either join a workgroup that does not have a password associated with the
ADMIN user, or enter the password it is asking for.
If you don't know the password, and you are using the default workgroup
(system.mdw), then you need to delete it and create a brand new fresh
workgroup file that does not have any passwords. When you delete the
system.mdw workgroup file and then open Access, it will create a new one for
you. You may need your install disks for this.
--
Rick B
"Galaxygirl" <(E-Mail Removed)> wrote in message
news:5054414D-3AF4-4661-B985-(E-Mail Removed)...
> Rick-
>
> I'm not joined to a secure workgroup file. It appears as a .mdb and when I
> open it 'user' is filled in in the password screen and needs a password.
> I'm
> not sure of the account it is referring to.
>
> Nor can I go in to the security settings of the db to let me in. (Wen I
> hit
> shift as I open the db- it doesn't get me in.)
>
> "Rick B" wrote:
>
>> A username and password are part of your workgroup file (mdw). The
>> templates on the website do not require a password.
>>
>> If you are currently joined to a secure workgroup file, either rejoin the
>> default system.mdw file or provide the userid and password that it is
>> asking
>> for.
>>
>> --
>> Rick B
>>
>>
>>
>> "Galaxygirl" <(E-Mail Removed)> wrote in message
>> news:2DF3BF15-F570-4752-ADE9-(E-Mail Removed)...
>> >I downloaded an Access template from the website. But I can't get into
>> >the
>> > database because it asks for a username and password. Is there a
>> > default
>> > username? Does that account have administrative rights to the database?
>>
>>
>>
|