accessing SQL via access 2003

R

R

hello all,

i am a newcommer to the world of SQL and building databases. i have been
working with microsoft products for quite a while and am an MCSE. i need help
with integrating and accessing data from an SQL 2000 server. how do you use
access to create and access data from an SQL server. PLEASE HELP!!!

Ross
 
J

Jeff Boyce

Ross

Open an Access database (new).

Select File | Get External Data | Link.

The type of data you want to link to is ODBC (probably at the bottom of the
drop-down list).

For Access to access data stored in SQL Server (or VisualFoxPro, or ...),
you have to build an ODBC "helper" file, AKA a Data Source Name (DSN). This
DSN tells Access how to reach (and handle) the data.

You will, of course, need appropriate permissions on the SQL Server side.
 
Top