By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,509 Members | 2,185 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,509 IT Pros & Developers. It's quick & easy.

I'M LOCKED OUT OF MY DATABASE

P: n/a
When I came in on Monday and tried to open my database, everything
worked fine until I tried to run the database splitter. It didn't
work, but when I tried to go back into my database, it says I have no
permission. It doesn't even recognize me as the owner anymore.
Help. I have info that I need in there.

What did I do? How can I fix it?

Feb 27 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<bm****@yahoo.comwrote
When I came in on Monday and tried to open my
database, everything worked fine until I tried to
run the database splitter. It didn't work, but when
I tried to go back into my database, it says I have
no permission. It doesn't even recognize me as the
owner anymore.
Help. I have info that I need in there.

What did I do? How can I fix it?
Let me understand, here... you ran code on your database that would
drastically alter its structure without making a backup copy? And, was this
original and only copy of the database secured?

I've run the splitter on a few databases, but always on a backup copy in
several different versions of Access and never had a similar situation. In
fact, the splitter does so little for me that I don't use it, as a general
rule, preferrring to make two backup copies... on one I delete all but the
tables and relationships, on the other I delete relationships and tables,
then use Get External Data to link the tables in the first copy.

There's some possibility that your database was corrupted during the
Splitter process. To try to fix that, in case that is what it is,

*** FIRST, MAKE A BACKUP COPY, OR TWO ****

then Open Access without opening a database, on the menu Tools | Database
Utilities | Compact and Repair Database <and cross your fingers, and hope
for the best>...

If that doesn't work, go to the Microsoft site and download a copy of
JetComp, which does much the same, but doesn't require opening the database
first.

If neither of these works, then you need to be specific and precise about
_exactly_ what is happening, and the _exact_ error message you receive, not
a paraphrase.

At the very worst, you will have to go back to the last good backup copy you
have, and will have learned an OBJECT LESSON about the experts MEANING WHAT
THEY SAY when they advise making BACKUP COPIES before doing maintenance on
your database, as well as making BACKUP COPIES on a regular basis as you use
the database.

Larry Linson
Microsoft Access MVP
Feb 27 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.