Hello,

I am new with SQL server and I would like to convert my Access 2003
database to use with SQL 2005. I know there is a tool in MS access
called Usizing Wizard to help me to do this, but can this tool convert
Access Forms, Querries and Reports to SQL as well?

One this database is migrated to the SQL server, how users are going to
use this database?

Thank you for your help.

CB

Hi there,

[quoted text, click to view]

The following articles may be of interest:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q325017
http://office.microsoft.com/en-us/assistance/CH062526781033.aspx

The first article references Access 2000, I believe it is still valid
in everything that it says.

Basically your entire DB structure will be transformed into a SQL
Server database and the wizard will attempt to change the queries you
have defined as described in the 2nd article (see About Upsizing > How
database objects get upsized > Queries).

Considering the SQL Server product in a stand-alone fashion it doesn't
have a concept similar to Access Forms (you have to code seperate apps
to access the DB) but you could replicate reports through the use of
SQL Server Reporting Services.

Either way, forms and objects probably won't be converted because there
is no equivalent object in SQL Server.

[quoted text, click to view]

How do your users access the database now? Do they open up the .mdb
file and work with Access Forms?

You could create new applications using something like VB.NET and
deploy them so that users can work with the database. However, it could
be quite time-consuming and users would have to learn something new.

In your case, you might be better off keeping Access as the front end
and using SQL Server as the backend. This is described in the articles
I gave links to before.

Hope that helps a bit, but sorry if it doesn't