>Hi... any body can help me.. how to export MDB to Ms. SQL 7 thru VB6's code and also how to it's user login? .. Thanks

SQL security is a lot different from Access. To set security in SQL through VB code, you will need to use SQL-DMO.

To export data, maybe have a look at the DTS wizard which can generate VB code for your re-use.

Also, have a look at http://www.microsoft.com/sql/techinfo/deployment/70/accessmigration.asp

And I hope that you don't expect Access reports, modules, queries to be upgradable as-is. I also hope that you don't think that your application is 100% compatible to SQL Server if it was written for Access.