ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> ROUTTEMP file will not link
http://www.istechforum.com/YaBB.pl?num=1233497321

Message started by rmh148 on 02/01/09 at 07:08:40

Title: ROUTTEMP file will not link
Post by rmh148 on 02/01/09 at 07:08:40

Does anyone know why the ROUTTEMP file will not link correctly. I get #Deleted in every field when I link it. I can Import is and it shows me everything. All other files are fine! Also, MTRO_OP_TEMP_NO shows to be a key but is blank in my table, Any clue whether that is correct or not?

Title: Re: ROUTTEMP file will not link
Post by Kelloggs on 02/02/09 at 11:00:03

Reindex your table.
Then use a pass-through query rather than linking the table. On your query dont include the MTRO_CODE field.

:-X

Kelloggs

Title: Re: ROUTTEMP file will not link
Post by rmh148 on 02/03/09 at 08:49:22

Thanks for the comments. I'll give it a try.