Not a Valid Password error in Access 2007

M

MKM

this didn't happen to me, so I'm sketchy on details!
A friend used the wizard split a database and set a password on the
_be.accdb. She opened the front end and is now getting a dialog box "not a
valid password" when she tries to open a (linked) table or even run a query.

thanks.
 
K

Klatuu

The password has to be included in the connect string. It ends up looking
like this:
MS Access;PWD=Fozzwa;DATABASE=\\SomeServer\SomFolder\SomeBe.mdb

When you use the Linked Table Manager, it should ask for the password and
create the correct connect string for you.
 
M

MKM

but where do I add that? In the from end? a module? Seems to me, if you
use a wizard to do something then you shouldn't be required to write code to
make it work. Is this a bug in 2007?
 
K

Klatuu

Not a bug that I know of.
The Linked Table manager should ask for a password if the back end database
is password protected.
 
M

MKM

unfortunately, it does not. I actually experimented with a copy of my own
database and received the same error. I split the database then set a
password on the _be.accdb. After that, I was unable to open any object in
the front end that reliwd on a table (all queries, some forms, all reports.)
When I opened the front end I was never presented an opportunity to enter a
password; I just got a dialog box stating 'not a valid password' When I open
the _be I do get a box asking for the password and I'm able to get into that
with no problem.

I'd like to try you previous solution, and I am familiar with VBA, but this
database has no code modules at all. Should I add it to the open event of
the startup form? do I have to create a module just for this? Again, it
doesn't seem right that one could use a wizard to get started but must then
write code to complete the desired effect.

thanks,
MKM
 
K

Klatuu

All you need to do is open your front end. If you have any startup form or
an autoexe macro, hold down the shift key when you open the mdb.
Delete all the tables in the tables window. It doesn't delete the tables,
in only deletes the links to the table. They are still in the back end.
Now relink your tables. When you try to link to a table, it will ask for the
password.
 
M

MKM

worked like a charm :eek:)

thanks ever so,
MKM

Klatuu said:
All you need to do is open your front end. If you have any startup form or
an autoexe macro, hold down the shift key when you open the mdb.
Delete all the tables in the tables window. It doesn't delete the tables,
in only deletes the links to the table. They are still in the back end.
Now relink your tables. When you try to link to a table, it will ask for the
password.
Click to expand...
 
Top