Shell to Access with SQL security

[Mega_Man]

Can someone tell me how to shell to access passing a username and password to a SQL Server.
I know how to do it using a Access MDW security file but I have a fron end that allows a user to enter a username and a password in VB which then shells out to the Access database.
Any help is appreciated.

Mega.

[darre1]

do you want to access the database using ADO or something, or actually open the database in access, but specifying the name and password automatically.???

[Mega_Man]

I have a VB front end which takes a username and password and used 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.

Mega.

[darre1]

ah, that's a little over MY head anyway