1 Access Question

[ANSWER]

Hi

The computer with XP is connected on domain.
If I want to make a new database, when I try to open Microsoft Access 2000,
I get next message:
Enter your user name and password.

I just want to know where is that protection started and how?
Thanks

 

[Joseph Meehan]

Hi

The computer with XP is connected on domain.
If I want to make a new database, when I try to open Microsoft Access
2000,
I get next message:
Enter your user name and password.

I just want to know where is that protection started and how?
Thanks

First question is what is asking you for a password and name? What
happens if you leave it blank and just hit enter?

 

[MacDermott]

That security is build into the workgroup (.mdw) file to which your computer
is attached.
If you need to use a username and password to use any other Access database
on your computer, you may have difficulties if you change this .mdw file.

If the above is not a problem, you can use the workgroup administrator at
C:\Program Files\Microsoft Office\Office\MS Access Workgroup
Administrator
to change your workgroup.
If you create a new workgroup file, it will not initially ask you for a name
and password.

But I would strongly advise you to read up on workgroup files and Access
security, to understand why your computer had been attached to this other
workgroup file.

HTH
- Turtle

 

[Joseph Meehan]

First question is what is asking you for a password and name? What
happens if you leave it blank and just hit enter?

I think I should add a little to that. The question I have is what
system is asking you're your password. It may be Access, the OS (Windows),
LAN software or security software.

If you have not set up your own personal password Access tends to
default to a blank field.

If it is Access security at work

I suggest you start by reading
http://support.microsoft.com/default.aspx?scid=kb;[LN];207793

Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.

Practice on some copies to make sure you know what you are doing.