I have a query that appends student information from the school admin database, to a table in my database.
The school db is accessed via an ODBC connection.
On one of my forms, there is a button that say "Update Student Data"
When the user clicks the button, a macro makes a call to the query.
The problem is that the end-user is always asked for username/password. (common to all users)
Is there a way that I can parse the UN/PW in the macro, when It calls the query?
eg in the "Query Name" box, why cant i I put
NameOfTheQuery, un=UserName, pw=Password
Is there another way to do this?
The school db is accessed via an ODBC connection.
On one of my forms, there is a button that say "Update Student Data"
When the user clicks the button, a macro makes a call to the query.
The problem is that the end-user is always asked for username/password. (common to all users)
Is there a way that I can parse the UN/PW in the macro, when It calls the query?
eg in the "Query Name" box, why cant i I put
NameOfTheQuery, un=UserName, pw=Password
Is there another way to do this?
