my table can not be seen anymore in Msysobject query

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
F

Frank Situmorang

Hello,

Before I split my table I can see the table in Mysobject query when I run my
combo that will look data from table or query.

In the my quey criteria under msysobject is 1 or 5. Can anybody help me why
I can not see any more table, because I want to see the data tobe export from
table not just query.

Thanks very much.
 
Hello,

Before I split my table I can see the table in Mysobject query when I runmy
combo that will look data from table or query.

In the my quey criteria under msysobject is 1 or 5. Can anybody help me why
I can not see any more table, because I want to see the data tobe export from
table not just query.

Thanks very much.
Click to expand...

Makes perfect sense. All the _attached_ tables have Type=6. Only
_local_ tables have Type = 1.
 
Piet Linden said:
Makes perfect sense. All the _attached_ tables have Type=6.
Only _local_ tables have Type = 1.
Click to expand...

Actually, tables linked using ODBC have type 4, not 6.
 
Douglas J. Steele said:
Actually, tables linked using ODBC have type 4, not 6.
Click to expand...

Rereading that, I see where what I wrote could be misinterpretted.

Local tables have Type = 1.
Attached tables which do not use ODBC (this includes linked spreadsheets and
text files) have Type = 6.
Attached tables which use ODBC have Type = 4.
 
Back
Top