Access97 Table Names in Designer

building semantic layer
1

I am creating a universe (4.1.3) on an Access97 database. I can add all of the tables (into the universe) I need from the Access database, but the tables with more than one word in their names (claim detail, claim header) cause errors when verifiying or any other query commands. The one word table names work fine in the universe. Does anyone have any suggestions for what the problem or solution might be? I am using the Generic ODBC drivers.

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

2

try placing quotes around the table name in the designer.

Donald May
E-mail: maydp@pweh.com

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

3

Steve,

Table names probably don’t like spaces. Try underscores. Remember to change the names in both access and Designer.

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