Unable to Obtain Table Information

[EXploringEA]

Started to check out the database builder.
Managed to set up connection and import schema all OK for access database. But then when I use the SQL Scratch Pad with simple SQL query e.g. SELECT * FROM t_authors

I get the message "Unable to Obtain Table Information" and no visible clues to what the error is.  I have tried various syntax changes as it states no pre-execution validate e.g. SELECT * FROM [t_authors] and making all caps but no clues on what's not working.

Seen in past post issues with ODBC drivers, but using 32-bit and that's all OK since the import worked OK; guess that's proof.

Anybody an idea of solution or where more information is logged that may help resolve.

Is there any more documentation on using the database builder than the single page in the CHM file?

Thanks

[qwerty]

First: which database?

q.

[EXploringEA]

Sorry - I'm using Access 2007 (accdb).
My test copied an eap file to accdb which seems to work fine.  The one conversion error I got was "The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions." But the tables looked fine and schema imported OK.

But then my joy of playing slowly disappeared :-?

Hopefully you can shed some light on the issue.

[qwerty]

You can send me a copy of your file privately and I can have a look (if it's not confidential).

q.

[RoyC]

What release of EA are you using? All builds of release 12 have quite a lot of Help on the Database Builder; for earlier builds the Help tended to assume that you might also be maintaining your database models 'the old way', later builds put the emphasis on using the Database Builder. But there is definitely more than one page of Help on it!

[EXploringEA]

Thanks to qwerty, who did a check to verify that it was my issue, so on further inspection I found I had used a wrong odbc driver combination, so with some new drivers downloaded from MS all working.  

I managed to use an mbd driver for an Access 2007 format file which worked fine in terms of importing the schema but not executing SQL.

@Roy - thanks, yes the latest chm for V12 has a few more pages on the database builder, so a little clearer.

And so now back to exploring this new feature of EA