I have 6 linked tables via ODBC. All tables can be opened and viewed with no problem. I can create select queries and results are displayed. I cannot click the totals and apply SUM to a numeric column. It does not give me a non-compatible field error, it gives me an odbc call fail which makes no sense.
The database was written in MS Access 2000 and has not worked properly since it was opened in MS Access 2007. I have searched the web for others reporting the issues and there are not many. I installed the latest hotfixes and SP3 with no luck.
Please let me know what other information would be helpful to troubleshoot.
THANKS in Advance!