Hi All,
I have an application that talks to an Access database through ODBC. The database has a password on it. I'd like to upsize it to SQL server. I can easily upsize it to SQL server, but the application does not work even when the ODBC connections are the same name. I assume this is because of the password (it is a basic password-only password). Is there a way to fool the application into getting past this? I know what the access password is, and have created a user in SQL with the same password, but to no avail. Thanks!
Jason
I have an application that talks to an Access database through ODBC. The database has a password on it. I'd like to upsize it to SQL server. I can easily upsize it to SQL server, but the application does not work even when the ODBC connections are the same name. I assume this is because of the password (it is a basic password-only password). Is there a way to fool the application into getting past this? I know what the access password is, and have created a user in SQL with the same password, but to no avail. Thanks!
Jason