PM80680: "TABLE '[TABLE NAME]' HAS NO COLUMNS AND WILL NOT BE SHOWN."

APAR status

• Closed as program error.

Error description

• You open  your MS Access 2007 *.accdb file via ODBC using
  Statistics 20.0  without incident.  You use the same ODBC data
  source in Statistics 21.0 and receive the error:
  "Table '[table name]' has no columns and will not be shown."
  

Local fix

• This issue will be addressed in the next Fix Pack. Please refer
  to the Fix Pack schedule at
  http://www-01.ibm.com/support/docview.wss?uid=swg21599157 for
  information on upcoming Fix Packs.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Statistics 21.0 32-bit trying to use ODBC with      *
  * Access 2007 database (*.accdb)                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * End user on SPSS Statistics 21 (x86) connecting to an Access *
  * 2007 database via ODBC (*.accdb).  The interface throws an   *
  * error:                                                       *
  *  "Table '[table name]' has no columns and will not be        *
  * shown."                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Statistics 21.0 Fix Pack 1.                       *
  ****************************************************************
  

Problem conclusion

• This issue has been addressed in Statistics 21.0 Fix Pack 1.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  SPSS STATISTICS

• Fixed component ID

  5725A54ST

Applicable component levels

• RL00 PSN

     UP

• RL00 PSY

     UP