Dennis:
I will list the steps you need to do in order to make this work. When you
use ODBC with Access all the part description fields when you view the
design of the table comes in as a memo field. This cannot be linked. So
here are the steps needed to correct this.
1. Create an append query using as an example the job head table(or
whatever table has the part desc). Use company, job num, and part desc.
Call the append query JobPartDescqry.
2. Run this query and it creates a table. Call it JobParttbl.
3. After the table JobParttbl is created, view it in design view and change
the part description to a text field and to whatever length you wish.
4. Use the JobPartTtlb in your other queries and you will now be able to
link to them.
5. Then create another query as a delete query using the JobPartDescqry
called delJobPartDescqry.
6. When all your queries are done then you need to create a macro starting
with opening the delJobPartDescqry. Then opening the JobPartDescqry. Then
running your final queries or reports.
Hope this helps. If you need further assistance feel free to contact me off
line.
-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Friday, March 01, 2002 9:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] vantage to access via odbc
Hi,
I am having problems trying to link tables into an access database. I am on
vantage 4.0, progress 9.0, and access 97. The odbc driver is merant 3.6.
I got the table jobprod into access, but when I try to link or import other
tables like jobhead, orderhead, orderdtl, etc, I get an error message saying
"Invalid field [part description] in definition of index or relationship",
the error message is for different fields in the different tables. The
common thing I,m seeing is that the error messages are all refering to
description fields. Does anyone know how to fix this?
Thanks in advance
Dennis
[Non-text portions of this message have been removed]
I will list the steps you need to do in order to make this work. When you
use ODBC with Access all the part description fields when you view the
design of the table comes in as a memo field. This cannot be linked. So
here are the steps needed to correct this.
1. Create an append query using as an example the job head table(or
whatever table has the part desc). Use company, job num, and part desc.
Call the append query JobPartDescqry.
2. Run this query and it creates a table. Call it JobParttbl.
3. After the table JobParttbl is created, view it in design view and change
the part description to a text field and to whatever length you wish.
4. Use the JobPartTtlb in your other queries and you will now be able to
link to them.
5. Then create another query as a delete query using the JobPartDescqry
called delJobPartDescqry.
6. When all your queries are done then you need to create a macro starting
with opening the delJobPartDescqry. Then opening the JobPartDescqry. Then
running your final queries or reports.
Hope this helps. If you need further assistance feel free to contact me off
line.
-----Original Message-----
From: Dennis Houghton [mailto:dennis@...]
Sent: Friday, March 01, 2002 9:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] vantage to access via odbc
Hi,
I am having problems trying to link tables into an access database. I am on
vantage 4.0, progress 9.0, and access 97. The odbc driver is merant 3.6.
I got the table jobprod into access, but when I try to link or import other
tables like jobhead, orderhead, orderdtl, etc, I get an error message saying
"Invalid field [part description] in definition of index or relationship",
the error message is for different fields in the different tables. The
common thing I,m seeing is that the error messages are all refering to
description fields. Does anyone know how to fix this?
Thanks in advance
Dennis
[Non-text portions of this message have been removed]