Access 2007 Password protect - locked out of a report now

  • Thread starter Thread starter NV
  • Start date Start date
N

NV

I created a database password. Everything seemed fine until I tried to open
a report and now get the error message "not a valid password". The other
reports seem fine but for some reason this one is locked up. Help please.
 
Yes, the report is in the same database that I protected and have since
unprotected. When I try to access the design view of the qry the report is
based on it will only open in SQL mode. I am not familiar enough with SQL to
figure out how to delete and recreate the links to the tables within this
database. Any other suggestions?
 
Right, I agree with that. I still think it has something to do with setting
the password though since the report correctly opened thru a command button
and also by clicking on the report itself just prior to adding a password. I
also find it odd that the qry now will not open in design view. It doesn't
make any sense to me. The other buttons as well as other reports are
unchanged.
 
Thank you Chris. I was mistaken. It just occurred to me that the query for
that report had an old link to a entirely separate database that I also
happened to put a password on and I didn't think to remove that password
since it was a link I probably put in place years ago. I guess I have too
many databases. I appreciate your help in getting my head in the right place
to solve my problem. I removed the linked table to solve the problem,
however, in the event that I wanted to have the database locked but still
linked to another database that was locked how then do I get around the 'not
a valid password' problem?
 
Back
Top