I have a VB front end which takes a username and password and use it to shell to the Access MDB file which had the security MDW file in the shell statement.
However, I have now migrated all the tables to SQL Server and I want to be able to shell MS Access and open the database passing the SQl security information instead of the standard Access MDW file.
BTW, I need to pass it the I.P. Address of the SQl and not the server name. ADO is not involved here at all as I am using MS Access as the initial database. I am only using a VB front end to pass user credentials as the MS Access one is crud.
Plz tell me if I can do this.
Eradic8or.
However, I have now migrated all the tables to SQL Server and I want to be able to shell MS Access and open the database passing the SQl security information instead of the standard Access MDW file.
BTW, I need to pass it the I.P. Address of the SQl and not the server name. ADO is not involved here at all as I am using MS Access as the initial database. I am only using a VB front end to pass user credentials as the MS Access one is crud.
Plz tell me if I can do this.
Eradic8or.
