linking tables to a password protected database

[Tmarkos]

I am working in access 2003. I have a report database that links to the main
database. I have added a password to the main database. Now I can't get it
to relink to the report database. It just tells me invalid password, but
never prompts for a password. Where do I add the password in the report
database? I tried just adding the same password to the report database, but
that didn't work, and I can't find a reference to this issue on the help or
in my database workbook.

 

[Jerry Whittle]

First delete the links to the main database in the Reports database. Then
create the links fresh.

 

[Klatuu]

You can change the connect string to include the database's password:

Set dbbackend = DBEngine(0).OpenDatabase(strFilename, False, False, "MS
Access;PWD=Bozo")

 

[tmarkos]

I have only done some minimal programing. I know how to view the sql, but
where would I insert this code?
Thanks,
Tina

 

[Klatuu]

where you link to the back end.
If delete all your links, then use the link table manager and give it the
password when it asks, it will save the password for you.