PC Review


Reply
Thread Tools Rate Thread

Access 2007 "compact and repair" asking password

 
 
wand
Guest
Posts: n/a
 
      1st May 2009
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
 
Reply With Quote
 
 
 
 
carp
Guest
Posts: n/a
 
      5th May 2009
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!!!

"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

 
Reply With Quote
 
Bar
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
Bar
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
carp
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
carp
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
Bar
Guest
Posts: n/a
 
      2nd Jun 2009
super thanks carp I will try that myself thanks for ur help

"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

 
Reply With Quote
 
New Member
Join Date: Nov 2011
Posts: 1
 
      29th Nov 2011
Thx alot

That helped.

Quote:
Originally Posted by Bar View Post
super thanks carp I will try that myself thanks for ur help

"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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2007 "compact and repair" asking password wand Microsoft Access 0 1st May 2009 10:42 PM
Access 2000 - "Compact and Repair" bug ? =?Utf-8?B?R2Fz?= Microsoft Access 3 28th Mar 2007 06:03 AM
RE: Access 2000 - "Compact and Repair" bug ? =?Utf-8?B?R2Fz?= Microsoft Access 0 28th Mar 2007 12:20 AM
RE: Access 2000 - "Compact and Repair" bug ? =?Utf-8?B?RGFuaWVs?= Microsoft Access 0 28th Mar 2007 12:09 AM
RE: Access 2000 - "Compact and Repair" bug ? =?Utf-8?B?R2Fz?= Microsoft Access 0 28th Mar 2007 12:02 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:48 PM.