Vantage and setting up Access

After you have ODBC configured open Access. Choose New Table, Link
Table. Change Files of Type to ODBC Databases. Choose your Data
Source name. A list of Vantage Tables will appear, choose the ones
you want to connect. Then the tables will appear in Access. After
that I always create a Make Table Query to create an Access Table
from the Linked Table with the fields I want to use, it will improve
performance by not using a live linked table to create reports.
You'll wait a little while the tables are made, but the reports will
run instantly. After I have Access tables for each linked table,
then I create whatever queries and reports I need.

HTH,

Brian Stenglein
Clow Stamping Co.

--- In vantage@yahoogroups.com, "mansfield1024" <johnm@g...> wrote:
> Hi to all,
>
> I would like to set up Access using the ODBC connection.
> First I want to know the risks of writing to Progress Vantage.
> I think all I have to do is link to the Merant driver for Vantage.
> All of the tables should be visable, I should then be able to
> create a querry then a report.
> Does this sound right or am I missing something?
>
> Thanks,
>
> John Mansfield
> General Sheet Metal
Hi to all,

I would like to set up Access using the ODBC connection.
First I want to know the risks of writing to Progress Vantage.
I think all I have to do is link to the Merant driver for Vantage.
All of the tables should be visable, I should then be able to
create a querry then a report.
Does this sound right or am I missing something?

Thanks,

John Mansfield
General Sheet Metal
I am out of the office until 2/18/2004. I shall contact you upon my return.

Kind regards

Newell, Ron


This information sent is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any storage devices.
www.pattisonsign.com
Penticton Office.