Append to a passworded database?

[sjl]

How can I get an external form/database to be able to append to a pass-worded database?

thanks
sjl

 

[WayPay]

You can't unless you know the password. However, if you have a non-password-protected frontend that links to that password-protected database, you can copy the table links from the frontend (hell, you could get the password itself) into your own database.

 

[sjl]

WayPay,

Thanks for your response. I do know the password--I have full permissions.

However, when I created a small database and tried to append to the passworded one, it said "You don't have permission--speak to your administrator" and does not prompt me for a password. Not sure under what menu I could get it to prompt me for a password?

SJL

 

[WayPay]

I take it, then, that the passworded db is not an Access db?

 

[sjl]

Actually, it is an Access db. They both are.

 

[sjl]

A-ha. I got access to the passworded db by doing the following:

Tools| Security| Workgroup Admin| Join ==> I browsed to the *.mdw file of my other database, and now it prompts me for my password.

Thanks,
Sjl

 

[WayPay]

If you create a table link to the target database, it should prompt you for the password. After that, just INSERT INTO the linked table. Or run an Append Query, if you prefer .