Recently I ran across the following error while trying to run a report. My "mini" data warehouse is stored in Microsoft Access. Report: Transactions for Heatmap Job: 836 Status: Execution failed Error: SQL Generation Complete QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42000:-1809: on SQLHANDLE] [Microsoft][ODBC Microsoft Access Driver] Cannot modify the design of table 'TTLOR2BS4MD000'. It is in a read-only database . Connection String: DSN=AnkeetFinancials;DBQ=C:\Users\ashah\Documents\AnkeetPersonalTransactions\FinancialTransactions.accdb;DRIVERID=25;FIL=MS Access;MAXBUFFERSIZE=2048;PAGETIMEOUT=5;UID=admin;. SQL Statement: create table TTLOR2BS4MD000 ( Transaction_Category TEXT(255), Statement_End_Date TIMESTAMP, Account_ID LONG, WJXBFS1 LONG, WJXBFS2 DOUBLE) .. QueryEngine encountered error: Report [Transactions for Heatmap]: Drop table error: DBI...
Two Plus One Is Us! Initially started out as a title for our family blog, it didn't take long to realize that when you blog, other person reads and a third person comments you essentially have a small group that is contributing to a meaningful discussion resulting in enrichment of minds and problem solving. That small group is Us.