Not a Valid Password error in Access 2007

[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.

 

[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.

 

[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?

 

[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.

 

[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

 

[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.

 

[MKM]

worked like a charm )

thanks ever so,
MKM

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.

 

[eibooo]

hey i got the same problemmmm but wen i delete all tables in front end the Linked Table manager icon gets disable ????

cud u please tell me on how to solve this pleaaaaaaaaaaaaaaaaaaaaase

thank u in advance

 

[eibooo]

Linked Table manager icon disabled wen delete front end tables...

hey i got the same problemmmm but wen i delete all tables in front end the Linked Table manager icon gets disable ????

cud u please tell me on how to solve this pleaaaaaaaaaaaaaaaaaaaaase

thank u in advance

 

[eibooo]

solved ...

i figured it out...

just have to import table as link...