We have an old access database on a win3.1 system and I moved it off to the
server. The access version is 2.0 and I converted it to Access 2k2. After
the conversion when you look up product info. some fields are missing from
the report. You get part numbers, weights, percentages, times, etc. but
customer and description fields come up #errror. I went through the
individual reports and the information is still there. Was wondering if
there was a link that was broken or whatever? If anyone knows I'm at your
mercy. TIA

dwojt

On Mon, 19 Jun 2006 08:04:02 -0700, dwojt
<(E-Mail Removed)> wrote:

>We have an old access database on a win3.1 system and I moved it off to the
>server. The access version is 2.0 and I converted it to Access 2k2. After
>the conversion when you look up product info. some fields are missing from
>the report. You get part numbers, weights, percentages, times, etc. but
>customer and description fields come up #errror. I went through the
>individual reports and the information is still there. Was wondering if
>there was a link that was broken or whatever? If anyone knows I'm at your
>mercy. TIA
>
>dwojt

There might have been some Access Basic code in the 2.0 application
that didn't convert properly to VBA (there was a *huge* change in
database architecture between A2.0 and A95). You'll need to open the
report in design view and examine the code, the Control Source
properties of these controls, the Query upon which the report is
based, and just dig through and debug it.

You say you went through the individual "reports" - do you mean the
Tables? Data isn't stored in reports!


John W. Vinson[MVP]