471,337 Members | 829 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

new project connect a 2003 database to pull variable/values off sql server

We have a new project here, one that I have never tried maybe its easy
I don't know yet.

We have people that have records dating back over 5 yrs on a sql
server.
We have to build an access 2003 database for data entry of the people
then pull data from the sql server to fill in data for these records.

that sounds good....except to start I need record # and date....no
problems there.
we then need to pull var1 var2 var3 from the sql server....well we
don't know what variables they are (sql server person) HUH
so they are told to go find out what they called them and supply a
list of variable names that corespond to the variables we need to
pull.

OK 4 months later we have the list of the 68 variable names as named
on the sql server....ROFL

ok enough of this bs..

is there a book out that talks about coding for connecting to a sql
server giving it the record # and date and then the variables that the
database needs to pull?

Like I said I have never tried this and don't even know where to
start.

thanks for any info I can use.

and don't worry i have the full support of the sql managers...as you
can tell LOL

Mar 28 '07 #1
4 1809
sparks wrote:
We have a new project here, one that I have never tried maybe its easy
I don't know yet.

We have people that have records dating back over 5 yrs on a sql
server.
We have to build an access 2003 database for data entry of the people
then pull data from the sql server to fill in data for these records.

that sounds good....except to start I need record # and date....no
problems there.
we then need to pull var1 var2 var3 from the sql server....well we
don't know what variables they are (sql server person) HUH
so they are told to go find out what they called them and supply a
list of variable names that corespond to the variables we need to
pull.

OK 4 months later we have the list of the 68 variable names as named
on the sql server....ROFL

ok enough of this bs..

is there a book out that talks about coding for connecting to a sql
server giving it the record # and date and then the variables that the
database needs to pull?

Like I said I have never tried this and don't even know where to
start.

thanks for any info I can use.

and don't worry i have the full support of the sql managers...as you
can tell LOL
I have no idea what the term "Variable" might mean in the context of SQL
Server the way you are using it. Stored Procedures and Triggers created on
SQL Server can contain variables, but those are not usable outside of the SP
or Trigger that defines them.

Normally one would link to or programmatically access TABLES on SQL Server
to get at the data in those tables. You'll need to explain further just
what you are talking about.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Mar 28 '07 #2
On Wed, 28 Mar 2007 13:45:15 GMT, "Rick Brandt"
<ri*********@hotmail.comwrote:
>sparks wrote:
>We have a new project here, one that I have never tried maybe its easy
I don't know yet.

We have people that have records dating back over 5 yrs on a sql
server.
We have to build an access 2003 database for data entry of the people
then pull data from the sql server to fill in data for these records.

that sounds good....except to start I need record # and date....no
problems there.
we then need to pull var1 var2 var3 from the sql server....well we
don't know what variables they are (sql server person) HUH
so they are told to go find out what they called them and supply a
list of variable names that corespond to the variables we need to
pull.

OK 4 months later we have the list of the 68 variable names as named
on the sql server....ROFL

ok enough of this bs..

is there a book out that talks about coding for connecting to a sql
server giving it the record # and date and then the variables that the
database needs to pull?

Like I said I have never tried this and don't even know where to
start.

thanks for any info I can use.

and don't worry i have the full support of the sql managers...as you
can tell LOL

I have no idea what the term "Variable" might mean in the context of SQL
Server the way you are using it. Stored Procedures and Triggers created on
SQL Server can contain variables, but those are not usable outside of the SP
or Trigger that defines them.

Normally one would link to or programmatically access TABLES on SQL Server
to get at the data in those tables. You'll need to explain further just
what you are talking about.
very sorry I don't know sql structure.
when said variable I was saying something like DOB for date of birth
or
I would ask for record # 1234567 on date 01/01/2007 and get the
persons gender from the sql database.

I was hoping to be able to do this by a single entity not pull in a
complete 10 years of data into the access database to get one bit of
information. I am assuming I just do a link table and then get what I
need that way but again I am not sure.

Mar 28 '07 #3
sparks wrote:
very sorry I don't know sql structure.
when said variable I was saying something like DOB for date of birth
or
I would ask for record # 1234567 on date 01/01/2007 and get the
persons gender from the sql database.

I was hoping to be able to do this by a single entity not pull in a
complete 10 years of data into the access database to get one bit of
information. I am assuming I just do a link table and then get what I
need that way but again I am not sure.
Well once you have a link to the SQL table then you would query it just like
you would an Access table.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Mar 28 '07 #4
Ok so just like a linked table in access...I guess since I have no exp
with sql I was looking at it like some foreign language.
On Wed, 28 Mar 2007 15:41:16 GMT, "Rick Brandt"
<ri*********@hotmail.comwrote:
>sparks wrote:
>very sorry I don't know sql structure.
when said variable I was saying something like DOB for date of birth
or
I would ask for record # 1234567 on date 01/01/2007 and get the
persons gender from the sql database.

I was hoping to be able to do this by a single entity not pull in a
complete 10 years of data into the access database to get one bit of
information. I am assuming I just do a link table and then get what I
need that way but again I am not sure.

Well once you have a link to the SQL table then you would query it just like
you would an Access table.
Mar 28 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by dw | last post: by
1 post views Thread by tcg_gilbert | last post: by
4 posts views Thread by shapper | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.