ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Manufacturing >> Problem linking Access to ROUTTEMP
http://www.istechforum.com/YaBB.pl?num=1325184069

Message started by dashdown on 12/29/11 at 11:41:09

Title: Problem linking Access to ROUTTEMP
Post by dashdown on 12/29/11 at 11:41:09

I am trying to create a report in Access based on the ROUTTEMP file. I have 27 records in this file. When I pull it up in Data Base Manager all the data is there and looks fine. When I pull in up in Access I have three records that have all the fields populate with “#Deleted”. I’ve run UT-C and UT-J but this hasn’t helped. Any Ideas what is wrong and how to fix this?

Title: Re: Problem linking Access to ROUTTEMP
Post by Kelloggs on 12/29/11 at 12:17:25

I think that table is for temporary store
Why dont you use the ROUTING table? what type of report are you trying to create?

:-[

Kelloggs

Title: Re: Problem linking Access to ROUTTEMP
Post by dashdown on 12/29/11 at 12:35:36

I believe ROUTTEMP is the table storing the routing templates If I'm wrong, what is the table I'm looking for to create a detailed listing of our routing templates?

Title: Re: Problem linking Access to ROUTTEMP
Post by Kelloggs on 12/29/11 at 12:37:02

ROUTING

:P

Title: Re: Problem linking Access to ROUTTEMP
Post by dashdown on 12/29/11 at 12:52:54

I guess I used the wrong term. I'm looking for the Operation Templates that are input in RO-I.

Title: Re: Problem linking Access to ROUTTEMP
Post by Kelloggs on 12/29/11 at 13:08:59

You were using the right table: ROUTTEMP
as per why is not showing all the records, best guess would be data corruption.
how to fix them?

Try ODBCDDF.RUN, but do it when no one is accessing evo tables via ODBC

if that does not work, I would export everything I can then recreate the table (ask lynn for instructions)
then import the data again

good luck

:-X