A
Acheron
Hello Everyone,
Having a database structure splitted in several levels, we use queries to
append/make tables in another database that the one contaning the data.
Those databases have a password set. Therefore, when creating an append
query, we choose "Another database" / then Browse / then pick up the
destination table. An input box prompts for the password / we fill it. Even
when controlling the password through the properties panel of the query,
everything seems alright (case, etc).
But when running the query, we always get an error message saying : "Not a
valid password".
We received the same message when running Make table queries & when trying
to do the same operation in VBA.
Does anyone have an idea ?!
TIA for your cooperation
Acheron
Having a database structure splitted in several levels, we use queries to
append/make tables in another database that the one contaning the data.
Those databases have a password set. Therefore, when creating an append
query, we choose "Another database" / then Browse / then pick up the
destination table. An input box prompts for the password / we fill it. Even
when controlling the password through the properties panel of the query,
everything seems alright (case, etc).
But when running the query, we always get an error message saying : "Not a
valid password".
We received the same message when running Make table queries & when trying
to do the same operation in VBA.
Does anyone have an idea ?!
TIA for your cooperation
Acheron