Hey everybody... thanks that is exactly the help I needed this morning. Bye
the way, I don't lick my computer but I do occasionally kiss it.
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 10:38 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Like I said, its been a Monday, I have cold and I'm doing shots of Nighttime
Nyquil.
I've sent 20 e-mails this morning and every one of them has had some kind of
mistake.
Jeremy
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Monday, October 28, 2002 11:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] automatic linking of tables
I saw that too Jeremy, sounds a little freudian if you ask me
Shirley
-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Monday, October 28, 2002 10:58 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Hey Jeremy, if you look at #9 you just told Lois to lick her computer.
You
might want to dust it off a little before you do step #9, Lois. Must be
Monday!
Ted Kitch
ted@...
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 9:51 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
We use Access 2000 as well.
Steps:
1)Delete current linked table.
2)From the file menu select Get External Data.
3)From that menu select Link Tables.
4)The Link table dialog box opens, change the "Files of Type" box to "ODBC
Databases()
5)The Select Data Source Dialog Box opens, choose the "Machine Datasource"
tab.
6)Select the ODBC DSN that you have setup for Vantage. Ours for example
is
"ProgressODBC"
7)The "Logon to Progress SQL-92 Driver" dialog opens.
8)Enter your password and then select OK.
9)The Linked Tables Dialog box will then open. In the lower right hand
corner you should see the "Save Password" checkbox. Put a check in it by
licking on it.
10)Select the tables you want to link and then click on "OK"
You should not you a File or User DSN when setting up ODBC.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Monday, October 28, 2002 10:41 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
I am in Access 2000 and do not see any Save Password box
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 9:30 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Relink all the tables. On the screen where you select the tables to link,
there is a small box in the lower right hand corner that says, "Save
Password". You need to select this.
That should fix your problems.
If not, feel free to call.
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Monday, October 28, 2002 10:25 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
When I open access and I chose the report I am interested in running I
have
to choose linked table manager which defines the tables and then I am
prompted for the ODBC login. IF I don't go through the ODBC login
process,
I will not get the report and the call to ODBC will fail. How should this
work and how do you handle it?
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 8:18 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
I guess I need more info. Once you link them, why do you have to relink
the
tables for each user? What version of Vantage and ODBC Driver? We use
Access allot linked to Progress.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: lheisey3 [mailto:lheisey@...]
Sent: Monday, October 28, 2002 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] automatic linking of tables
Has anyone ever developed a routine or macro that allows automatic
linking of tables to the ODBC data source so as to not have to go
through the routine each and ever time? We used access to modify our
Packing list and are using ODBC to link to the files. For each user
who needs to print this pack list we would like this process
automated. Any ideas?
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=221745.2287884.3710693.2146399/D=egroupweb/S=17050071
83:HM/A=1207826/R=0/*http:/www.buywirelessnow.com/sonyericsson/handset_T68i.
asp>
<http://us.adserver.yahoo.com/l?M=221745.2287884.3710693.2146399/D=egroupmai
l/S=:HM/A=1207826/rand=525064641>
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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
the way, I don't lick my computer but I do occasionally kiss it.
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 10:38 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Like I said, its been a Monday, I have cold and I'm doing shots of Nighttime
Nyquil.
I've sent 20 e-mails this morning and every one of them has had some kind of
mistake.
Jeremy
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Monday, October 28, 2002 11:17 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] automatic linking of tables
I saw that too Jeremy, sounds a little freudian if you ask me
Shirley
-----Original Message-----
From: Ted Kitch [mailto:ted@...]
Sent: Monday, October 28, 2002 10:58 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Hey Jeremy, if you look at #9 you just told Lois to lick her computer.
You
might want to dust it off a little before you do step #9, Lois. Must be
Monday!
Ted Kitch
ted@...
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 9:51 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
We use Access 2000 as well.
Steps:
1)Delete current linked table.
2)From the file menu select Get External Data.
3)From that menu select Link Tables.
4)The Link table dialog box opens, change the "Files of Type" box to "ODBC
Databases()
5)The Select Data Source Dialog Box opens, choose the "Machine Datasource"
tab.
6)Select the ODBC DSN that you have setup for Vantage. Ours for example
is
"ProgressODBC"
7)The "Logon to Progress SQL-92 Driver" dialog opens.
8)Enter your password and then select OK.
9)The Linked Tables Dialog box will then open. In the lower right hand
corner you should see the "Save Password" checkbox. Put a check in it by
licking on it.
10)Select the tables you want to link and then click on "OK"
You should not you a File or User DSN when setting up ODBC.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Monday, October 28, 2002 10:41 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
I am in Access 2000 and do not see any Save Password box
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 9:30 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
Relink all the tables. On the screen where you select the tables to link,
there is a small box in the lower right hand corner that says, "Save
Password". You need to select this.
That should fix your problems.
If not, feel free to call.
Jeremy Leonard
IT Manager
K-T Corporation
317-398-6684
-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Monday, October 28, 2002 10:25 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
When I open access and I chose the report I am interested in running I
have
to choose linked table manager which defines the tables and then I am
prompted for the ODBC login. IF I don't go through the ODBC login
process,
I will not get the report and the call to ODBC will fail. How should this
work and how do you handle it?
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Monday, October 28, 2002 8:18 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] automatic linking of tables
I guess I need more info. Once you link them, why do you have to relink
the
tables for each user? What version of Vantage and ODBC Driver? We use
Access allot linked to Progress.
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
-----Original Message-----
From: lheisey3 [mailto:lheisey@...]
Sent: Monday, October 28, 2002 9:07 AM
To: vantage@yahoogroups.com
Subject: [Vantage] automatic linking of tables
Has anyone ever developed a routine or macro that allows automatic
linking of tables to the ODBC data source so as to not have to go
through the routine each and ever time? We used access to modify our
Packing list and are using ODBC to link to the files. For each user
who needs to print this pack list we would like this process
automated. Any ideas?
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
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 http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://rd.yahoo.com/M=221745.2287884.3710693.2146399/D=egroupweb/S=17050071
83:HM/A=1207826/R=0/*http:/www.buywirelessnow.com/sonyericsson/handset_T68i.
asp>
<http://us.adserver.yahoo.com/l?M=221745.2287884.3710693.2146399/D=egroupmai
l/S=:HM/A=1207826/rand=525064641>
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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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/.
(2) To search through old msg's goto:
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
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/