By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 849 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

connecting to a sql server to get specific values

P: n/a
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.
Oct 29 '08 #1
Share this Question
Share on Google+
3 Replies


P: n/a
-----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.

Oct 29 '08 #2

P: n/a

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 <me@privacy.comwrote:
>-----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
Oct 31 '08 #3

P: n/a
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…
Oct 31 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.