Logon Name and Password

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear all, I have been playing with security level on Access and I have no
Idea what i have done, but now access is asking for logon name and password,
and no matter what I enter it says invalid, even I use exactly as is on the
saved security report, how can i cancell all that? even if i want to create a
new database it asks for name and password.

please help
 
Have you read this and other newsgroups on the subject of Access security?
If so, do you recall that almost everyone who's actually used it said, in no
uncertain terms, work on a COPY of your database?

Access security can't keep a determined cracker out, but when we are just
learning it, it may very well keep _us_ out.

Please, don't tell me you have no unsecured backup copy... please...

Larry Linson
Microsoft Access MVP
 
thanks for reply, and now i know i shouldn't have played with security thing.
I have an unsecured copy of the data base, but no matter what, access asks
for logon name and password, as I said even when i want to create a new
database, it asks the same thing, so i beleive what i have done is something
more than just securing the database itself. has it anything to do with SQL
Server, on access help it mentions something about sql server.

by the way, if i log in to windows under different user, it opens the
database with no problem, only when i log into the windows with my original
name, access locks me out.

please help
 
Ah, you have "joined a workgroup" -- not one of the best design decisions
ever made by The Boys and Girls in Redmond (to assume that all secured
databases would be used by the same user would have the same workgroup).

You may have also altered the default workgroup, but, if you have not, the
simplest way to undo what you have done is, on the database window menu, if
you have Database administrator authority, Tools | Security | Workgroup
adminstrator and try to Join C:\WINDOWS\system32\system.mdw. That is the
default workgroup installed by Access. If that doesn't work, look in the
same Workgroup administrator list under User and Group Accounts and click
the Clear Password button for User Name: Admin.

Because Access security is, to put it politely, "fallible", I avoid it to
the extent possible. Thus, if what I have suggested does not work for you,
you might have a lot better luck if you visit the newsgroup dedicated to
Access security, microsoft.public.access.security.

Larry Linson
Microsoft Access MVP
 
thanks larry, I did what you said and i am back in business, you saved me
larry.

thank you
 
thanks larry, I did what you said and i am
back in business, you saved me larry.
Click to expand...

I'm glad it was helpful.

I had feared you might have to "ask the experts" in
microsoft.public.access.security.

Larry Linson
Microsoft Access MVP
 
Dear Larry:

From what I've heard, you need special permission to post to that newsgroup!

Tom Ellison
 
Just to add something, as Larry says the idea of joining a workgroup doesn't
work all that well. I think the best solution is to stick with the default
workgroup, and then just use the /wrkgrp switch in shortcuts when accessing
secured mdbs. That allows you to just use the workgroups you've created
only when they're actually required.
 
Tom Ellison said:
From what I've heard, you need special
permission to post to that newsgroup!
Click to expand...

Hi, Tom, I'm glad you are posting again. Now that you are, I may have to
subscribe to the Queries/SQL newsgroups, because I really admire your
abilities* in that particular area of Access...

* for which, you could also read, "stand in awe of your abilities" (but I
didn't want to give you a swelled head <GRIN>)

I'm surprised to hear there's any restriction on posting to any
microsoft.public... newsgroup.

Best regards,

Larry
 
Dear Larry:

It is only because the "security" newsgroup is, well, more secure. Being
secure increasingly means "inconvenient", right?

Swlled head? I'm going to need some Crisco just to get throught he doorway
now! The source of the praise you give is such a high place.

So, now, how is your head?

Tom Ellison
 
Back
Top