Password Automation

[BSkelding]

I am trying to find a way to have the password for a database entered automatically based on a persons username.

Here is the situation:

There is an opening database, we'll call it Login.fp5, where the user logs in. If the user is a valid user it then takes them to Main.fp5 via a script. Main.fp5 has two passwords, Admin and User. When Main.fp5 is opened it prompts for a password. Is there a way to automate this so the user never sees the password dialog? Ideally I would like to pass the password to Main.fp5 via the script that opens it. I'm not sure how to accomplish this if it is even possible.

Thanks for you help,

Brian

[dmaxj]

I have a similar problem, too, but I guess it would fall under password automation.

I need to know if there is a way to automatically send a password to a table that requires a password.

I need to access a valuelist in the passworded table, and I need to make a relationship between both tables.

Thanks

[Fitch]

Take a look at the thread here on Opener Files. It goes into quite a bit of detail on this sort of thing.