[AccessD] Access to SQL Server

Jim Lawrence (AccessD) accessd at shaw.ca
Mon Nov 24 21:11:59 CST 2003


Hi Tom:

You do not have to give up your Access Front-End and it is straight-forward
to connect to a SQL7/2000 Back-End. 450 orders through a MS SQL DB would be
effortless on the SQL server. You can either use ODBC, setup through your
control panel or ADO-OLE, setup directly through your Access. There are a
number of steps to go through and it would be best to ask the 'list' when
you reach an impasse, on the specific problem, then continue until the next
crisis. The recommended list group to get involved with would be the SQL
list at http://dba-sqlserver@databaseadvisors.com (That list specialists in
MS SQL issues.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Tom Keatley
Sent: Monday, November 24, 2003 3:38 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Access to SQL Server


Hi all...

I contract to a large company producing some goods which require me to
process 450 individual orders each month. These orders come from 450
different sources and are (currently) sent to me via 450 individual excel
spreadsheets. To this end I have developed an Access database to process
these orders and also produce the goods.

In the New Year the company is going to change their ordering system to SQL
server and all orders will be placed over the Web therefore centralising
their ordering system. They have asked me what information I need to produce
what I normally do from the server. I think the move is WELL overdue BUT...

I  know little (OK... NOTHING) about SQL server and its capabilities and
would not know the most efficient way of extracting the data.

The data I need is Customer name and address (approx 450), Description of
goods (Up to 700 items Per customer), and quantity to buy.

My head tells me that read only access to a query via ODBC into SQL Server
is the way to go   but many of you are working with Access AND SQL server
and I thought I would ask within the group for advice.

Can I talk technically about SQL server the way I talk about Access ....ie
is the terminology the same as in Tables, Queries, Forms and Modules etc
(certainly dont want to appear stupid when talking about it)

What connection options are there (I am physically 3000 miles from the
server)

The little I have gleaned about SQL server suggests that it is like the "Big
Brother" to Access which means that I can talk about it the way I would talk
about Access but ......am I correct?

As always any help would be appreciated

Regards

Tom Keatley



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list