Brian,
Here is an EraNet article
(link: http://eranet.epicor.com/ansbook/vantage/public/4/49/494/494mps.htm) covering Access and Part Description Lengths. Notice the last sentence says there is a way to shorten the Part Description. Epicor gave me the instructions on this (which I don't have any longer) and I believe this would solve your problem if the other suggestions below don't.
Troy
---------------Beginning of EraNet Article------------------
Page: 494MPS
Summary: Active link between Access and Prog 9.0 DB, Invalid field de
AnswerBook: Vantage ChangeRequests
I am able to setup an active link to my Progress 9.0 DB with Access 97, but when I try to set an active link to the Part table, I receive an invalid field description error.
This may be able to be fixed with a minor settings change for the ODBC driver. On the workstation where ODBC was installed, open up control panel, then the ODBC applet. Find the Progress driver under the user dsn tab, highlight it and click on the configure tab. Next click on the advanced tab, locate a check box for ANSI SQL COMPLIANCE and place a check in the box. You should now be able to create an active link to the Part table.
If you are still unable to create an active link, there may be other factors involved. The part description field contains a possible 1000 characters which may cause some conflicts listed below
Issue 1).Access 97 works on Jet engine which can only handle so many characters in an indexed field.
Issue 2).The Merant 3.5 driver doubles the number of characters when it grabs them from the Progress database.
Possible solutions
1).Access 2000 does not use the Jet engine and could handle the many character indexed field.
2).Merant 3.6 driver does not double the number of characters when it grabs them from the Progress databse.
Another possible solution may be to change the number of characters exported to ODBC within the data dictionary (changing the character format). Between Access and the Merant 3.5 driver, there may be a problem linking to a field with more than 24 characters. Further information on how to change a description fields charcter size should be directed to tech support.
------------------END of EraNet Article -------------------------
Here is an EraNet article
(link: http://eranet.epicor.com/ansbook/vantage/public/4/49/494/494mps.htm) covering Access and Part Description Lengths. Notice the last sentence says there is a way to shorten the Part Description. Epicor gave me the instructions on this (which I don't have any longer) and I believe this would solve your problem if the other suggestions below don't.
Troy
---------------Beginning of EraNet Article------------------
Page: 494MPS
Summary: Active link between Access and Prog 9.0 DB, Invalid field de
AnswerBook: Vantage ChangeRequests
I am able to setup an active link to my Progress 9.0 DB with Access 97, but when I try to set an active link to the Part table, I receive an invalid field description error.
This may be able to be fixed with a minor settings change for the ODBC driver. On the workstation where ODBC was installed, open up control panel, then the ODBC applet. Find the Progress driver under the user dsn tab, highlight it and click on the configure tab. Next click on the advanced tab, locate a check box for ANSI SQL COMPLIANCE and place a check in the box. You should now be able to create an active link to the Part table.
If you are still unable to create an active link, there may be other factors involved. The part description field contains a possible 1000 characters which may cause some conflicts listed below
Issue 1).Access 97 works on Jet engine which can only handle so many characters in an indexed field.
Issue 2).The Merant 3.5 driver doubles the number of characters when it grabs them from the Progress database.
Possible solutions
1).Access 2000 does not use the Jet engine and could handle the many character indexed field.
2).Merant 3.6 driver does not double the number of characters when it grabs them from the Progress databse.
Another possible solution may be to change the number of characters exported to ODBC within the data dictionary (changing the character format). Between Access and the Merant 3.5 driver, there may be a problem linking to a field with more than 24 characters. Further information on how to change a description fields charcter size should be directed to tech support.
------------------END of EraNet Article -------------------------
----- Original Message -----
From: Troy Funte
To: vantage@yahoogroups.com
Sent: Thursday, October 18, 2001 5:42 PM
Subject: Re: [Vantage] ODBC Problems
There is a separate utility from Epicor you have to run to actually shorten the PartDescription for Part. Again, you would be best off to call Epicor about this. In 5.0 the PartDescription got lengthened to 1000(x) and changed to a memo field instead of text. Truncating it allows it to be used in Crystal Groups and Formula's as well.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Brian Boyes
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 18, 2001 2:34 PM
Subject: RE: [Vantage] ODBC Problems
Darn. I spoke too soon. I can now access two of the four tables that my
Access application needs. WrkCenter and LaborDtl now function, but when I
try to access JobHead or Part, I get an error "Invalid field definition
'PartDescription' in definition of index or relationship."
We have not modified the tables in any way, which would have been my first
thought. So anyway, I'm still looking for ideas.
Thanks!
Brian
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]
Yahoo! Groups Sponsor
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]