Welcome, Guest. Please Login.
04/19/24 at 14:49:26
News:
Home Help Search Login


ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
ROUTTEMP file will not link (Read 1448 times)
rmh148
Member
**




Posts: 84
ROUTTEMP file will not link
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?
 
Back to top
 
 
  IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: ROUTTEMP file will not link
Reply #1 - 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.
 
  lips sealed
 
Kelloggs
Back to top
 
 
Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
rmh148
Member
**




Posts: 84
Re: ROUTTEMP file will not link
Reply #2 - 02/03/09 at 08:49:22  
Thanks for the comments.  I'll give it a try.
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Crystal Reports, ODBC & Access › Access General Issues ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge