Symptoms
When using DAO/Jet to access an Oracle database, you get either blank rowsback in a grid or rows filled with #DEFINE (when using Access).
Resolution
This behavior is caused by DAO having a problem determining the datatypefor Oracle columns defined as NUMBER.