ODBC: Microsoft Access

Yahoo Archive
1
I notice a change in the table names with the new ODBC driver. They all
begin with PUB... or maybe I'm not using it properly.

Mercer Sisson

-----Original Message-----
From: Ryan Larkin [mailto:rlarkin@...]
Sent: Friday, October 05, 2001 10:19 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC: Microsoft Access


Good morning.

I just recently installed Version 5.0 from Version 4.0 and have run into
a problem with my reports that I created in Microsoft Access. Since my
reports where using the ODBC for Version 4.0 do I need to start from
scratch and create these reports with the new ODBC driver for Version
5.0?

Any suggestions or help would be very appreciative.

Thank you,

Ryan Larkin
Vice President
Solid Comfort, Inc. / Solid Performance
Fargo, ND
701-282-4900



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=212180.1660613.3195489.1269402/D=egroupweb/S=17050071
83:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=212180.1660613.3195489.1269402/D=egroupmai
l/S=1705007183:HM/A=812074/rand=201079834>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Good morning.

I just recently installed Version 5.0 from Version 4.0 and have run into
a problem with my reports that I created in Microsoft Access. Since my
reports where using the ODBC for Version 4.0 do I need to start from
scratch and create these reports with the new ODBC driver for Version
5.0?

Any suggestions or help would be very appreciative.

Thank you,

Ryan Larkin
Vice President
Solid Comfort, Inc. / Solid Performance
Fargo, ND
701-282-4900
3
It was over a year ago, but when I went from 3.0 to 4.0, I did not have to
re-create all of my access reports. However, I did have to do a link update
in Access. Unfortunately, it was so long ago that I don't remember what it
was and I did not write it down. I believe I found it the first time be
searching Access's help and looking at menu options, however. Also, I did
have to so some minor tweaking to my reports do to database changes.
4
Its been a while ago so I don't exactly remember what I had to do,
but we did face the same problem when going from 4 to 5. The ODBC
driver they give you with 5 is very different from the old drivers.
I was told by support to revert back to an older driver and I think
everything worked fine after I did that. I am using the Merant 3.6
Driver and I used ODBC quite a bit with good success.

Brian Stenglein
Clow Stamping Company

--- In vantage@y..., "Ryan Larkin" <rlarkin@s...> wrote:
> Good morning.
>
> I just recently installed Version 5.0 from Version 4.0 and have run
into
> a problem with my reports that I created in Microsoft Access.
Since my
> reports where using the ODBC for Version 4.0 do I need to start from
> scratch and create these reports with the new ODBC driver for
Version
> 5.0?
>
> Any suggestions or help would be very appreciative.
>
> Thank you,
>
> Ryan Larkin
> Vice President
> Solid Comfort, Inc. / Solid Performance
> Fargo, ND
> 701-282-4900
5
What you need to do is in Access go to Tools, Addins, Linked Table Manager,
Select all, then Ok. This will re-establish the link to the Vanatage tables.
This will need to be done for each report and each time there is a Vantage
upgrade the your reports should run fine. You would also have to look at
any changes within the table and the fields you are using. Hope this helps.

Joanne Yargeau
Taylor-Pohlman Inc

-----Original Message-----
From: bstenglein@... [mailto:bstenglein@...]
Sent: Friday, October 05, 2001 11:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC: Microsoft Access


Its been a while ago so I don't exactly remember what I had to do,
but we did face the same problem when going from 4 to 5. The ODBC
driver they give you with 5 is very different from the old drivers.
I was told by support to revert back to an older driver and I think
everything worked fine after I did that. I am using the Merant 3.6
Driver and I used ODBC quite a bit with good success.

Brian Stenglein
Clow Stamping Company

--- In vantage@y..., "Ryan Larkin" <rlarkin@s...> wrote:
> Good morning.
>
> I just recently installed Version 5.0 from Version 4.0 and have run
into
> a problem with my reports that I created in Microsoft Access.
Since my
> reports where using the ODBC for Version 4.0 do I need to start from
> scratch and create these reports with the new ODBC driver for
Version
> 5.0?
>
> Any suggestions or help would be very appreciative.
>
> Thank you,
>
> Ryan Larkin
> Vice President
> Solid Comfort, Inc. / Solid Performance
> Fargo, ND
> 701-282-4900



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=212180.1660613.3195489.1269402/D=egroupweb/S=17050071
83:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b15334027000300
0>

<http://us.adserver.yahoo.com/l?M=212180.1660613.3195489.1269402/D=egroupmai
l/S=1705007183:HM/A=812074/rand=300624540>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]