error reading tables

building semantic layer
1

Can somebody help me with the following problem?

I’m building a universe on a Microsoft Access '97 Database. When I try to view the Table Values of my fact tables I get the following message : [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in FROM clause.
My datamodel has 2 fact tables and a few dimension tables. The view table values options works with the dimension tables.

When I test the universe in BO reporter I get the same error message, with an extra comment: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in FROM clause.-3506

I’m using BO 4.1 on windows’95.

Thanks in advance for your replies.

Olaf

Olaf Prevo
EIM/ Small Business Research & Consultancy PO Box 7001
2701 AA Zoetermeer
tel.: +31 79 341 3634
fax: + 31 79 341 5024
email: OPR@EIM.NL
WWW: http://www.eim.nl

Listserv Archives (BOB member since 2002-06-25)

2

Mike Malone@CONTEXT
06/26/98 08:36 AM

You might want to verify that you have the Access97 ODBC drivers installed instead of the Access95 drivers.

Listserv Archives (BOB member since 2002-06-25)

3

Olaf wrote:

Can somebody help me with the following problem? I’m building a universe on a Microsoft Access '97 Database. When I try to view the Table Values of my fact tables I get the following message : [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in FROM clause.
My datamodel has 2 fact tables and a few dimension tables. The view table values options works with the dimension tables. When I test the universe in BO reporter I get the same error message, with an extra comment: [Microsoft][ODBC Microsoft Access 97 Driver] Syntax error in FROM clause.-3506
I’m using BO 4.1 on windows’95.

Listserv Archives (BOB member since 2002-06-25)