H
Hans
Hi,
I have the following quetion and I am sure somebody has the answer.
I have a MS Acces database where the tables have been created by linking via
an ODBC connection to our database.
I designed the queries and in several of these I forgot to set "Save
password" so every first time I run this or one of these queries I am
prompted to enter the ODBC connection password. Other queries on the other
hand I did not forget this and they run without this prompt and once one of
these has run or during the whole session, the password is 'remembered'.
I would like to edit the queries where I forgot to set "Remember Password"
but I cannot find wher I can do this.
My workaround is a dummy startup macro running one of the 'good' queries and
closing it thus avoiding the prompt.
Does anybody have a tip for me?
Thanks,
I have the following quetion and I am sure somebody has the answer.
I have a MS Acces database where the tables have been created by linking via
an ODBC connection to our database.
I designed the queries and in several of these I forgot to set "Save
password" so every first time I run this or one of these queries I am
prompted to enter the ODBC connection password. Other queries on the other
hand I did not forget this and they run without this prompt and once one of
these has run or during the whole session, the password is 'remembered'.
I would like to edit the queries where I forgot to set "Remember Password"
but I cannot find wher I can do this.
My workaround is a dummy startup macro running one of the 'good' queries and
closing it thus avoiding the prompt.
Does anybody have a tip for me?
Thanks,