Security

[vbgladiator]

Here's the scenario.

I have a front end application in Access and the tables are linked to the back end. I set a password on the back end. However, if I run the following line in the front end:

docmd.openform "formname", etc.

I receive an error telling me that the password is incorrect. Is there a place where I have to put the password in my front end as well?

[vbgladiator]

just bumping it to the top.

[mlewis]

If you are using a DSN, "dbname" you need to set it there. See control panel for DSN info.

If you aren't using a DSN but instead connect with a file name "C:\jfjfjfjjfkjsaklldkjjf\hfklahfkjd.mdb" then you use "file name=jfkfkadsljkfjdlkasj; pwd=kasjfkld"