SQL Database - How to Link to? Other Questions? Help?

[KGlennC]

I am designing an ACCESS 2007 Inventory Tag Control database for my Company.
I need to link to or import information from various SQL tables within a SQL
database.

For example, I would like to either link to or import the item numbers and
descriptions.

The SQL database resides on my Company's server. I can see the database
(it's a *.ndf file). I will be running ACCESS 2007 from a workstation on the
Company's network or from a remote PC logged into the network.

All workstations and the remote PC have XP Professional (SP3) OS. The server
has Windows 2000 Server (SP4).

Two Questions:
1. Import - How do I import specific SQL tables? What specific software,
other than ACCESS 2007, do I need on the remote PC?

2. Link - How do I link to specific SQL tables? What specific software,
other than ACCESS 2007, do I need on the workstation?

Links to resource answers (e.g., ACCESS/SQL Links for Dummies) would be
appreciated... I just need to know where to go or training resources to
purchase.

I am willing to PAY for initial guidance if my request is beyond the bounds
of this Forum or too complicated to be addressed in this Forum.

[Note: In the interim, I can (and have) created the tables I need within
ACCESS 2007... the Tag Control Program works "as is".... I'm looking for a
way to automate certain aspects of the Inventory Tag Control program.]

Thanks in advance.

K. Glenn Cole, President
Wilmot Company, Inc.

 

[Clifford Bass]

Hi Glenn,

You will need to set up an ODBC Data Source Name (DSN) that connects to
the server. See your company's technical support people for help with that
as it will be specific to your company's server and its settings. I would
make it a System (Machine) DSN. Once you have a DSN set up on your machine,
open up the Access database and then go to the External ribbon. In the
Import section choose More and then ODBC Database. Choose Link or Import
depending on which you want. Click OK. You will get a dialog for choosing
the data source. Change to the Machine Data Source tab and choose your new
DSN. Log in if needed. You will then get a list of the tables available to
you. Click on each one that you want and then click on OK. If some are
views you will be prompted to specify the field or fields that identify a
unique record. Choose them if you know. Otherwise just click OK. That
should do it.

Clifford Bass

 

[KGlennC]

Thanks. Will try.

Hi Glenn,

You will need to set up an ODBC Data Source Name (DSN) that connects to
the server. See your company's technical support people for help with that
as it will be specific to your company's server and its settings. I would
make it a System (Machine) DSN. Once you have a DSN set up on your machine,
open up the Access database and then go to the External ribbon. In the
Import section choose More and then ODBC Database. Choose Link or Import
depending on which you want. Click OK. You will get a dialog for choosing
the data source. Change to the Machine Data Source tab and choose your new
DSN. Log in if needed. You will then get a list of the tables available to
you. Click on each one that you want and then click on OK. If some are
views you will be prompted to specify the field or fields that identify a
unique record. Choose them if you know. Otherwise just click OK. That
should do it.

Clifford Bass

I am designing an ACCESS 2007 Inventory Tag Control database for my Company.
I need to link to or import information from various SQL tables within a SQL
database.

For example, I would like to either link to or import the item numbers and
descriptions.

The SQL database resides on my Company's server. I can see the database
(it's a *.ndf file). I will be running ACCESS 2007 from a workstation on the
Company's network or from a remote PC logged into the network.

All workstations and the remote PC have XP Professional (SP3) OS. The server
has Windows 2000 Server (SP4).

Two Questions:
1. Import - How do I import specific SQL tables? What specific software,
other than ACCESS 2007, do I need on the remote PC?

2. Link - How do I link to specific SQL tables? What specific software,
other than ACCESS 2007, do I need on the workstation?

Links to resource answers (e.g., ACCESS/SQL Links for Dummies) would be
appreciated... I just need to know where to go or training resources to
purchase.

I am willing to PAY for initial guidance if my request is beyond the bounds
of this Forum or too complicated to be addressed in this Forum.

[Note: In the interim, I can (and have) created the tables I need within
ACCESS 2007... the Tag Control Program works "as is".... I'm looking for a
way to automate certain aspects of the Inventory Tag Control program.]

Thanks in advance.

K. Glenn Cole, President
Wilmot Company, Inc.