Help! Locked out...

[Zaz]

Hello,

Sorry for the urgent subject line, but I'm in trouble here ;-) Here's what
happened...

I've had a properly secured database for the past year and a half and never
had any problems logging in. All of a sudden, I can't log into my database
getting an error stating, "You do not have the necessary permissions to use
the xxxx.mdb object". It seems this message is coming from Access. I click
on the shortcut, Access opens, and I get the message before the login screen
appears.

I've made backup copies of the database and tried pulling those back in, but
to no avail. Please let me know what I might try to fix this...I have huge
amounts of time into this database.

Thanks...

 

[Joan Wild]

I've had a properly secured database for the past year and a half and
never had any problems logging in. All of a sudden, I can't log into
my database getting an error stating, "You do not have the necessary
permissions to use the xxxx.mdb object". It seems this message is
coming from Access. I click on the shortcut, Access opens, and I get
the message before the login screen appears.

It likely isn't using the correct workgroup file. Check the target of your
shortcut - what is in it?

 

[Zaz]

It should be pointing to the right information, nothing seems to have changed
there. This is what I have...

Target: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"J:\Topicapp\07SOP97\PDTS\PDTS.mdb" /wrkgrp "J:\Topicapp\07SOP97\PDTS\User
Info\System.MDW"

Start in: "J:\Topicapp\07SOP97\PDTS\User Info"

Could it be the workgroup file itself that became corrupt? If so, how do I
go about recreating it? If not, what else might I try?

 

[Zaz]

UPDATE:

I also created a Data Link file to test the connection to the database and
connected with no problem (I am an administrator). So it seems that the
security .mdw file is intact, but again, I'm not an expert in this stuff.
With this info in mind, it still makes me think that there is an issue going

 

[Joan Wild]

It should be pointing to the right information, nothing seems to have
changed there. This is what I have...

Target: "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"J:\Topicapp\07SOP97\PDTS\PDTS.mdb" /wrkgrp
"J:\Topicapp\07SOP97\PDTS\User Info\System.MDW"

Start in: "J:\Topicapp\07SOP97\PDTS\User Info"

Could it be the workgroup file itself that became corrupt? If so,
how do I go about recreating it? If not, what else might I try?

The message doesn't indicate that. Try this. Open via your shortcut and
click OK on the error message. Then use Ctrl-G to open the immediate
window. ?Type
?dbengine.systemdb

What does this return?

 

[Zaz]

Upon your instructions, this is the return I received...

J:\Topicapp\07SOP97\PDTS\User Info\System.MDW

 

[Joan Wild]

Upon your instructions, this is the return I received...

J:\Topicapp\07SOP97\PDTS\User Info\System.MDW

The only thing that I can come up with is that someone has overwritten the
system.mdw that was in that folder with their standard system.mdw that ships
with Access. That would cause no login, and silently log you in as Admin -
thus no permission.

It's one reason why you should give your secure mdw files a different name.

Your only recourse is to restore the secure system.mdw from a backup, or if
you have all the names and PIDs written down, you can recreate it.

 

[Zaz]

Joan,

Thank you for all of your help, I am having the PC Support people pull the
backup tapes so we can restore tomorrow. In the meantime, I have a couple
last questions for you...

1. How would I go about recreating the System.MDW file? I went into the
Workgroup Administrator and it doesn't seem too cut and dry. Is there a step
by step process layed out somewhere online?

2. Since I can connect to the db by other means, is there an application or
utility out there that would allow me to connect and import all of the
tables, forms, etc.?

I'll keep you posted as this database has months of work involved and we
don't want to lose it

Zaz

 

[Joan Wild]

1. How would I go about recreating the System.MDW file? I went into
the Workgroup Administrator and it doesn't seem too cut and dry. Is
there a step by step process layed out somewhere online?

There's the security FAQ.
http://support.microsoft.com/?id=207793
You'd create a new workgroup file using the exact same organization name
string and PID as the original.
Then you'd create the same groups (again exact same names/PIDs).