Converting Access database to SQL server 2005

DimaSafr

I have a task to convert MS Access database to sql server 2005.
In addition to the database, on access front-end, I have forms, macros, modules and some DML. How easy it is to convert some or all of these components to sql server 2005?

DimaSafr

I just tryed to use MS Access upsizing withard but it could not connect to the SQL server. Probably this option does not work with SQL 2005. I am going to try SQL Server Mangment Studio express with Advanced services. Lets try, shell we.