<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