A
AlanB
I'm trying to link to another users database in a read only manner (I'm going
to be creating reports and the user does NOT want any chance of me or other
users to delete or alter data).
I saw in another post to get to the tables via a query and the IN and
DISTINCT (that is fine, I can do that)
However this database has a password (it is software created by an external
company and they password protect so only specified people can get to tables)
I have the password and have no password to link to the tables (a password
prompt comes up when trying to link) but when i try to get to table via query
(and sql statement to see it) I don't get a pop-up promt just an error
message. How can I enter the password via the SQL.
Thanks
to be creating reports and the user does NOT want any chance of me or other
users to delete or alter data).
I saw in another post to get to the tables via a query and the IN and
DISTINCT (that is fine, I can do that)
However this database has a password (it is software created by an external
company and they password protect so only specified people can get to tables)
I have the password and have no password to link to the tables (a password
prompt comes up when trying to link) but when i try to get to table via query
(and sql statement to see it) I don't get a pop-up promt just an error
message. How can I enter the password via the SQL.
Thanks