ISTech Support Forum - Problem linking Access to ROUTTEMP

Welcome, Guest. Please Login.

	05/10/25 at 00:04:51 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›

Pages: 1

Problem linking Access to ROUTTEMP (Read 916 times)

dashdown

Full Member

Be alert. The
world needs more
lerts.

Posts: 189
Gender: male

Problem linking Access to ROUTTEMP
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?

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: Problem linking Access to ROUTTEMP Reply #1 - 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
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	Re: Problem linking Access to ROUTTEMP Reply #2 - 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?
Back to top	IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: Problem linking Access to ROUTTEMP Reply #3 - 12/29/11 at 12:37:02 ROUTING
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

dashdown Full Member Be alert. The world needs more lerts. Posts: 189 Gender:	Re: Problem linking Access to ROUTTEMP Reply #4 - 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.
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: Problem linking Access to ROUTTEMP
Reply #5 - 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

lips sealed

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Manufacturing

‹ Previous topic | Next topic ›