connecting to a sql server to get specific values

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sparks
    #1

    connecting to a sql server to get specific values

    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.


    Tags: None
    • MGFoster
      #2
      Re: connecting to a sql server to get specific values

      -----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:::mgf0 0 <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/AwUBSQjjNoechKq OuFEgEQKO1ACg4x gR61T6Bm1pmWN3Z 32xuN4gxWwAoKec
      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.
      >
      >

        Comment

        • sparks
          #3
          Re: connecting to a sql server to get specific values


          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.com wrote:
          >-----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

            Comment

            • sparks
              #4
              Re: connecting to a sql server to get specific values

              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…


                Comment

                Previous template Next
                Working...