sql server new users:
Could you briefly explain how to set up ODBC to create links so I can easily
transfer my MS Access Tables and related forms, roports, and queries to SQL
Server or point me to a good article or web site? I am just starting to learn
SQL Server and need to import my existing tables, forms, reports, and queries
from Access to SQL Server.

I used MS SQL Server Data Transformation Service (DTS) wizzard to import my
MS Access Tables to SQL Server, but do not see my reports, forms, or queries
that I had in MS Access.

Will I have to recreate all my forms, reports, and queries in SQL Server
that were in MS Access, and is the GUI interface in SQL Server for using
forms, reports, and queries totally different than MS Access.

I hope this clears up some of your misperceptions.

The GUI interface for SQL Server (the Enterprise Manager) is not for
the end user; it is simply an interface for a limited number of
individuals (the database administrative staff) to manage the SQL
Server. As such, there is no such thing as a SQL Server form or
report.

Access is both a database server and a client application; you use VBA
to create form and report objects to interact with the inherent
database behind it. SQL Server is only a database server; to access
the data, you need a client (a web page, Access, an application written
in the programming language of your choice, etc..). Now that you've
migrated your tables, you could link them back to Access, and continue
to use your forms and reports, or you'll have to rewrite your forms and
reports using a different client application.

As for queries in Access, these are roughly akin to views and stored
procedures in SQL Server; however, Access's version of SQL (Jet SQL) is
different than SQL Server's version of SQL (T-SQL). That's probably
the reason why your queries didn't import over.

The simplest thing to do would be to drop all of your tables in your
access database (make a backup copy first), and then import them all
from SQL Server (using an ODBC connection). With a little tweaking in
the naming conventions, you could get your Access application up and
running with SQL Server on the backend. Of course, you run into
locking issues when multiple people try to design forms and reports,
but there are ways around that.

Hope that gets you started,
Stu