SAGE 50 - Accessing historical tables via ODBC - tJEHxx, tHEAHxx etc.

[Michelle Duford]

Sorry if this is the wrong forum, I could't find one specific to this question.

I am trying to access the historical (prior year) tables tJEHxx, tHEAHxx via ODBC.  I am aware that they would be in the actual format of: tJEAH01,tJEAH02 etc. I am looking at the dataDict2025 so assume this would be accurate.  Using Sage Accountant 2025 -- Canadian Version.

I am able to access the current year tables -- for example tJourEnt, tAccount etc via the ODBC driver.  I know there is historical information because I see in the financial reports.

Does anyone know if these tables are somehow hidden from the ODBC driver? Or is there some other secret to accessing the historical (prior year) transactions via ODBC?

Thank you for any insight to this.

Michelle

[Michelle Duford]

Sorry typo in my post.  It is tJeahxx not tHeahxx.  

[Michelle Duford]

I sorted this out.  Case is VERY important.