New Post - Owner deleted - No backups, nothing!

[Why ME?]

Joan Wild gave up! Can anyone else help me?

Database (MS Access 2003) That someone deleted the designer of the DB.

No one knows anything, but I do not know enough about it to hack into it. I
have asked for Network Admin rights to the folder it is in and all files in
that folder.

Still waiting for those rights.

I have rights to the DB, but can not even look at the macros. I can look at
the queries and tables and forms, but can not modify anything on them.

I must somehow unsecured the DB and get ownership of it again. I am not
sure if anyone other then the designer had admin rights, but somehow they
managed to delete him and I am not even sure what his user name was.

Why Me?

 

[Graham R Seach]

Joan Wild is an MVP, whom I doubt would have just "given up"!

I have not seen your original thread, so I can't comment on what you were
told, but it seems to me that since you can see the queries, tables and
forms, but not change anything, then what you have is an MDE or ADE. If
that's the case, then you're just out of luck, and there's nothing that
anyone can do about it. End of story.

Can you verify the file extension? MDB, MDE, ADP, ADE?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Why ME?]

Graham: Thank you for responding! here is a copy of the old post:

how do I find who is an admin? Can I make myself an admin?

Well some user has to be a member of the Admins Group - log in as that user.

I have read many of Joan's posts looking for an answer to this mess. I
"hear" in her writing condescending tone and not enough patience for a "MVP"

I have 13 years with MS Access and I really need help in this matter. I have
avoided Access Security because of great "Network" security where I have been.

If this is a dead-end, please reconmend software that can be bought.

I can not beleive that Microsoft wrote such a poor Security feature that
someone can blow away the creator of the DB and yet not be able to become
"Owner" of the DB.

 

[Graham R Seach]

....and that's giving up?? Joan is starting to guide you through the
troubleshooting process. Take her advice - see if someone else in the
organisation is able to log on. If so, problem partially solved - come back
and ask what to do next. If not, then come back and ask for more help -
don't just pass her advice off as having "given up".

Also, I notice you still haven't answered my question! Can you verify the
file extension? MDB, MDE, ADP, ADE?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

 

[Keith Wilby]

Joan Wild gave up!

This isn't an MS helpdesk and no-one owes you a reply. Had you considered
that Joan might have left her PC for a few days? I'm sure she has a life
away from here, as do we all.

Do you have the correct workgroup file?

Keith.

 

[Why ME?]

Graham: It is a mdb file and yes I have the correct workgroup and yes I have
had a person login in who set me up and no they do not have anymore
premissions than I do.

 

[Graham R Seach]

Then the only thing I can think of is to purchase a security cracker, in
order to discover the Admin password. Try Googling for "access password
recovery".

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

 

[Why ME?]

Graham: Thanks for your help on this! Sorry I rocked the boat in "MVP"
land....

 

[Graham R Seach]

No prob; we're all good swimmers.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------

 

[virtualkeeper via AccessMonster.com]

Is the problem that you can't change anything or that you literally can't see
code, table choices, etc.?

When the database opens up, hold down shift while clicking on Open. If your
problem is that the window doesn't show any tables options, forms, macro's
choices, etc. that should take care of the problem.

Hope that helps and if it doesn't well maybe someone else will stumble across
it in a time of need.

 

[Joan Wild]

Sorry dear, I did not give up. I went on vacation for a week (indeed am
still on vacation).

Given that you can get into the tables/queries/macros, I suspect that you
have a mde file. Just because it has a mdb extension, doesn't mean it is a
mdb. That could have been changed.

Also since someone was able to get in and 'set up your account', that
username is a member of the Admins group.