ODBC (again)

Yahoo Archive
1
Hey Guys:

I've seen this before and (if I remember correctly) the fix for this
problem is to upgrade the Jet version on your workstation where
you're running MS Access.

Go to this URL and download Jet 4.0:
http://support.microsoft.com/support/kb/articles/Q239/1/14.ASP

At the bottom of that page they have "#Deleted in Linked Table
Containing UniqueIdentifier" under the issues resolved section. I
think this will fix ya' up.

D. Smith



--- In vantage@y..., Brian Davis <bdavis@w...> wrote:
> Thanks for the response. At least I know I'm not alone. Now I
just have to
> figure out how to deal with it...B
>
> -----Original Message-----
> From: Gitzlaff, Christopher [mailto:cgitzlaff@m...]
> Sent: Wednesday, December 20, 2000 9:43 AM
> To: 'vantage@egroups.com'
> Subject: RE: [Vantage] ODBC (again)
>
>
> Brian,
>
> I've had the same problems with Access. I was working on the
report for the
> 1099's and wanted to use the primary vendor contact. In the
Vendcnt table,
> half of the records show up as #Deleted, just like yours. I was
told by
> Vantage support that this is a problem between Access and
Progress. The
> only workaround I've found is an export to Excel, then an import
into MS
> Access. Unfortunately, the report results were not correct until I
did the
> export/import routine on the Vendcnt table.
>
> I feel your pain.
>
> Christopher Gitzlaff
> Manager - Information Systems & Technology
> Major Industries, Inc.
>
>
> -----Original Message-----
> From: Brian Davis [mailto:bdavis@w...]
> Sent: Wednesday, December 20, 2000 10:30 AM
> To: 'vantage@egroups.com'
> Subject: [Vantage] ODBC (again)
>
>
> Has anyone tried to use JOBPROD in an MS Access program? I have
written
> some programs, reports, and queries, using the latest Merant driver.
> Mostly, they work fine, with the exception of the errors we talked
about a
> few months ago. However, yesterday I tried to use the JOBPROD
table for the
> first time. The data does not display. In all fields of all
records, the
> data displays as "#Deleted". I can use it in queries, and the
criteria I
> enter against JOBPROD results in the correct records. I can tell
this
> because the data from other linked tables in the query show up
correctly.
> Only the fields from JOBPROD display wrong.
>
> Any response would be greatly appreciated...B
>
>
> We no longer allow attachments to files. To access/share Report
Files,
> please go to the following link:
http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try
it, go to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the
link above
> will work the next time you try it.)
>
>
> We no longer allow attachments to files. To access/share Report
Files,
> please go to the following link:
http://www.egroups.com/files/vantage/
> (Note: If this link does not work for you the first time you try
it, go to
> www.egroups.com, login and be sure to save your password, choose My
Groups,
> choose Vantage, then choose Files. If you save the password, the
link above
> will work the next time you try it.)
2
Has anyone tried to use JOBPROD in an MS Access program? I have written
some programs, reports, and queries, using the latest Merant driver.
Mostly, they work fine, with the exception of the errors we talked about a
few months ago. However, yesterday I tried to use the JOBPROD table for the
first time. The data does not display. In all fields of all records, the
data displays as "#Deleted". I can use it in queries, and the criteria I
enter against JOBPROD results in the correct records. I can tell this
because the data from other linked tables in the query show up correctly.
Only the fields from JOBPROD display wrong.

Any response would be greatly appreciated...B
3
Brian,

I've had the same problems with Access. I was working on the report for the
1099's and wanted to use the primary vendor contact. In the Vendcnt table,
half of the records show up as #Deleted, just like yours. I was told by
Vantage support that this is a problem between Access and Progress. The
only workaround I've found is an export to Excel, then an import into MS
Access. Unfortunately, the report results were not correct until I did the
export/import routine on the Vendcnt table.

I feel your pain.

Christopher Gitzlaff
Manager - Information Systems & Technology
Major Industries, Inc.


-----Original Message-----
From: Brian Davis [mailto:bdavis@...]
Sent: Wednesday, December 20, 2000 10:30 AM
To: 'vantage@egroups.com'
Subject: [Vantage] ODBC (again)


Has anyone tried to use JOBPROD in an MS Access program? I have written
some programs, reports, and queries, using the latest Merant driver.
Mostly, they work fine, with the exception of the errors we talked about a
few months ago. However, yesterday I tried to use the JOBPROD table for the
first time. The data does not display. In all fields of all records, the
data displays as "#Deleted". I can use it in queries, and the criteria I
enter against JOBPROD results in the correct records. I can tell this
because the data from other linked tables in the query show up correctly.
Only the fields from JOBPROD display wrong.

Any response would be greatly appreciated...B


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
4
Thanks for the response. At least I know I'm not alone. Now I just have to
figure out how to deal with it...B

-----Original Message-----
From: Gitzlaff, Christopher [mailto:cgitzlaff@...]
Sent: Wednesday, December 20, 2000 9:43 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] ODBC (again)


Brian,

I've had the same problems with Access. I was working on the report for the
1099's and wanted to use the primary vendor contact. In the Vendcnt table,
half of the records show up as #Deleted, just like yours. I was told by
Vantage support that this is a problem between Access and Progress. The
only workaround I've found is an export to Excel, then an import into MS
Access. Unfortunately, the report results were not correct until I did the
export/import routine on the Vendcnt table.

I feel your pain.

Christopher Gitzlaff
Manager - Information Systems & Technology
Major Industries, Inc.


-----Original Message-----
From: Brian Davis [mailto:bdavis@...]
Sent: Wednesday, December 20, 2000 10:30 AM
To: 'vantage@egroups.com'
Subject: [Vantage] ODBC (again)


Has anyone tried to use JOBPROD in an MS Access program? I have written
some programs, reports, and queries, using the latest Merant driver.
Mostly, they work fine, with the exception of the errors we talked about a
few months ago. However, yesterday I tried to use the JOBPROD table for the
first time. The data does not display. In all fields of all records, the
data displays as "#Deleted". I can use it in queries, and the criteria I
enter against JOBPROD results in the correct records. I can tell this
because the data from other linked tables in the query show up correctly.
Only the fields from JOBPROD display wrong.

Any response would be greatly appreciated...B


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)