MS SQL Server queries

  • Thread starter Thread starter Tom Ross
  • Start date Start date
T

Tom Ross

I have a database with frontend and backend with linked tables.

We will soon be installing Microsoft SQL Server for our accounting system.

I assume that I will be able to use that server to serve data to my access
frontends
I assume that I will have a lot to learn to do this.

Can you reccommend some resources (URLs or book references) that I could
start reading
to start learning how to make the change.

I will probably be back with specific questions once I start the conversion.
Is there a more
appropriate newsgroup?

Thanks.

Tom Ross
 
Dear Tom:

Like so many portions of Access, the interface to SQL Server is VERY
usable without having to learn a great deal, yet there are many rich
features you cannot exploit without the learning that goes with them.
So, your learning curve can be as gradual or steep as you desire.

You must create a DSN entry, usually through your Control Panel. Then
you'll be able to "Link" SQL Server tables into an MDB application.
It may take an hour or so to learn to do the steps for this.

Once you have "Linked" a table this way, you can write the same Jet
queries as for other tables in your MDB.

There are facilities to fully exploit the considerable power of SQL
Server far beyond this, especially when writing ADPs instead of MDBs,
which are native to SQL Server databases - so much so that the MSDE
version of SQL Server is supplied with Access 2000 and later.

For the initial steps of getting into this, I have used and would
recommend:

Access 200X Developer's Handbook (set of 2 volumes) where X depends on
the version of Access, Litwin/Getz/Gilbert Sybex

Inside SQL Server 2000, Soukup/Delaney Microsoft Press

Enjoy! I went down this road over 3 years ago myself! I gauge it was
not a mistake.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Thanks Tom

I appreciate the time you took. Although you didn't give me a lot of how-to
detail you surely eased my nerves
a little. I will check out the references you mentioned. I'm going to try
for the steep learning curve

Tom
 
Thanks Tom

I appreciate the time you took. Although you didn't give me a lot of how-to
detail you surely eased my nerves
a little. I will check out the references you mentioned. I'm going to try
for the steep learning curve

Tom
 
Back
Top