Home All Groups Group Topic Archive Search About

Access 2007 "compact and repair" asking password

Author
1 May 2009 9:48 PM
wand
Hi all,

I have a database in Access 2007 format, with a password. Usually after I
open and modify the database, I do "compact and repair" to reduce database
size without any problem. But last time when I did compacting, database asked
me for password. Even though I input correct password, it showed "not a valid
password" and won't compact database.

More strangely, when I open database exclusively to remove password, it
shows "Encrypt with Password" which should be "Decrypt Database" under
"Database Tools" tab. So I can't remove or change the password.

I don't know what is wrong here. It is appreciated if anyone could help!

Thanks!!!

wand

Author
4 May 2009 11:38 PM
carp
Hello - I have the EXACT same problem and have been searching for a
resolution on this for quite some time.  If anyone has some suggestions that
would be extremely helpful!

Thanks!!!

Show quoteHide quote
"wand" wrote:

> Hi all,
>
> I have a database in Access 2007 format, with a password. Usually after I
> open and modify the database, I do "compact and repair" to reduce database
> size without any problem. But last time when I did compacting, database asked
> me for password. Even though I input correct password, it showed "not a valid
> password" and won't compact database.
>
> More strangely, when I open database exclusively to remove password, it
> shows "Encrypt with Password" which should be "Decrypt Database" under
> "Database Tools" tab. So I can't remove or change the password.
>
> I don't know what is wrong here. It is appreciated if anyone could help!
>
> Thanks!!!
>
> wand
Author
27 May 2009 11:49 AM
Bar
Hello did you get a solution on this as i have same problem

Show quoteHide quote
"wand" wrote:

> Hi all,
>
> I have a database in Access 2007 format, with a password. Usually after I
> open and modify the database, I do "compact and repair" to reduce database
> size without any problem. But last time when I did compacting, database asked
> me for password. Even though I input correct password, it showed "not a valid
> password" and won't compact database.
>
> More strangely, when I open database exclusively to remove password, it
> shows "Encrypt with Password" which should be "Decrypt Database" under
> "Database Tools" tab. So I can't remove or change the password.
>
> I don't know what is wrong here. It is appreciated if anyone could help!
>
> Thanks!!!
>
> wand
Author
27 May 2009 3:15 PM
carp
I sent my database to an expert to look at the problem and all they could
tell was the file was corrupt.  They told me they created a new databse and
imported the tables/queries/forms/reports from my corrupt databse and
everything appeared to reset.  I have been using the new database for a few
days now and am able to compact & repair and reset my password.  Hope this
helps you!


Show quoteHide quote
"Bar" wrote:

> Hello did you get a solution on this as i have same problem
>
> "wand" wrote:
>
> > Hi all,
> >
> > I have a database in Access 2007 format, with a password. Usually after I
> > open and modify the database, I do "compact and repair" to reduce database
> > size without any problem. But last time when I did compacting, database asked
> > me for password. Even though I input correct password, it showed "not a valid
> > password" and won't compact database.
> >
> > More strangely, when I open database exclusively to remove password, it
> > shows "Encrypt with Password" which should be "Decrypt Database" under
> > "Database Tools" tab. So I can't remove or change the password.
> >
> > I don't know what is wrong here. It is appreciated if anyone could help!
> >
> > Thanks!!!
> >
> > wand
Author
2 Jun 2009 1:29 PM
Bar
super thanks carp I will try that myself thanks for ur help

Show quoteHide quote
"carp" wrote:

> I sent my database to an expert to look at the problem and all they could
> tell was the file was corrupt.  They told me they created a new databse and
> imported the tables/queries/forms/reports from my corrupt databse and
> everything appeared to reset.  I have been using the new database for a few
> days now and am able to compact & repair and reset my password.  Hope this
> helps you!
>
>
> "Bar" wrote:
>
> > Hello did you get a solution on this as i have same problem
> >
> > "wand" wrote:
> >
> > > Hi all,
> > >
> > > I have a database in Access 2007 format, with a password. Usually after I
> > > open and modify the database, I do "compact and repair" to reduce database
> > > size without any problem. But last time when I did compacting, database asked
> > > me for password. Even though I input correct password, it showed "not a valid
> > > password" and won't compact database.
> > >
> > > More strangely, when I open database exclusively to remove password, it
> > > shows "Encrypt with Password" which should be "Decrypt Database" under
> > > "Database Tools" tab. So I can't remove or change the password.
> > >
> > > I don't know what is wrong here. It is appreciated if anyone could help!
> > >
> > > Thanks!!!
> > >
> > > wand