just upgraded to MS Office Accounting Pro 2008. I used to be able to get some basic information in VBA, but now it seems the table definitions have changed. The following would get me my checkking balence: SELECT Balance as VAL FROM BankAccountEntityView WHERE Name = 'Checking' Now it gets me my balence, before I upgraded. I looked for a new database, but did not find one. Also the folowing would get my current A/P and A/R totals, but now does not: SELECT Balance AS val FROM FinancialAccountEntityView WHERE (Name = N'Accounts Receivable') SELECT Balance AS val FROM FinancialAccountEntityView WHERE (Name = N'Accounts Payable') What has happened in versio 2008, please help.
