connecting to a sql server to get specific values

[sparks]

When the person doing the data entry is entering data into a subform,
I need to connect to a sql server and get specific value based on the
record number and date.
There is 15 values I have to retrieve while the person is entering the
record.

When the person enters the date, I need to connect and retrieve the
values and update the access table, as well as display them in the
form.

can someone tell me a GOOD BOOKthat will discribe this kind of thing,
how its done as well as other things I might need to know when using
access to connect and retrieve values from sql ?

Nice explenations of different connection routines and what to expect.

thanks for any info on this type of thing.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can get info on how to link to SQL Server tables here:

http://support.microsoft.com/kb/892490/en-us

--
MGFoster:::mgf00 <atearthlink <decimal-pointnet
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSQjjNoechKqOuFEgEQKO1ACg4xgR61T6Bm1pmWN3Z32xuN 4gxWwAoKec
xTfyMzV6iFE/506FiS9okHWX
=PEi3
-----END PGP SIGNATURE-----
sparks wrote:

When the person doing the data entry is entering data into a subform,
I need to connect to a sql server and get specific value based on the
record number and date.
There is 15 values I have to retrieve while the person is entering the
record.

When the person enters the date, I need to connect and retrieve the
values and update the access table, as well as display them in the
form.

can someone tell me a GOOD BOOKthat will discribe this kind of thing,
how its done as well as other things I might need to know when using
access to connect and retrieve values from sql ?

Nice explenations of different connection routines and what to expect.

thanks for any info on this type of thing.

[sparks]

I looked at this.

I was wondering if there are any books on this topic or something like
using an access database as a frontend for a sql server. All of this
type of thing I am wanting to read up on and learn about.
On Wed, 29 Oct 2008 15:27:10 -0700, MGFoster <[e-mail]:

>-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can get info on how to link to SQL Server tables here:

http://support.microsoft.com/kb/892490/en-us

[sparks]

what I had found out was this.

I just checked our Access installation. “Add Linked Table” seems to
support ODBC. I suppose I would use that. Just link in the table you
want to see. Then your database thinks it has a local table that is
always up-to-date. Assuming that SQL Server supports ODBC (I imagine
it does) and that there is a SQL Server database to look at in the
first place…