Shell to Access with SQL security

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.

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.???

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.

ah, that's a little over MY head anyway :(