Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Warning

This issue is caused by using a 32-bit version of Microsoft Office with a 64-bit version of Windows.


Problem

  1. Run a summary table query in the DataMart client
  2. The following error appears:

Solution

Multiple solutions may resolve this issue

  1. Check your Datamart settings. Ensure you are connecting directly to an Access database via an ODBC connection and are not connecting to an SQL database via an ODBC connection
  2. Ensure all columns in all tables in your Summary Table Access database are configured correctly
    1. Insert specs here
    2. You can also troubleshoot this by manually running the SQL query in Access and commenting out sections of the query until you identify the section that causes the error message. The section will indicate the table and columns which need to be have their data type changed.


Filter by label (Content by label)
showLabelsfalse
max5
spacesKB
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel in ( "access" , "odbc" , "dmc" ) and type = "page" and space = "KB"
labelsodbc access dmc