I am trying to write an MS Acces 97 application that will be use by several users, each with a different login name and password in MySQL. The first time I set a the ODBC Connection and link the table, everything works fine.
However, if I copy the Access file to a different computer and create the ODBC connection on it, I cannot connect automatically to the tables and must enter the user's password again in the connection window. It seems that Access somehow remembers the first user name or password and disregards the details I enterred in the ODBC connection. It doesn't matter whther I mark "Save password" when linking the tables.
Is there a way to bypass it? Can I change the password when the user run the application? The application will eventually run with the runtime version of access (as an MDE file), so if there is a way, it must be suited to work with it.
However, if I copy the Access file to a different computer and create the ODBC connection on it, I cannot connect automatically to the tables and must enter the user's password again in the connection window. It seems that Access somehow remembers the first user name or password and disregards the details I enterred in the ODBC connection. It doesn't matter whther I mark "Save password" when linking the tables.
Is there a way to bypass it? Can I change the password when the user run the application? The application will eventually run with the runtime version of access (as an MDE file), so if there is a way, it must be suited to work with it.