Re: MS-Access and CLI/I-NET

M. Livenspargar wrote: > > I've searched the USENET archives and haven't found the answer to this > particular problem -- I'll appreciate any help you can give me. > > We're trying to attach Informix tables to an otherwise empty MS-Access > v2.0 database. We're able to attach views and tables without primary > keys. When we try to attach a table that has a primary key, Access > give us a message "owner_tablename is not a valid name" where owner is > the owner of the table and tablename is the table name. > > Unfortunately, I don't have the exact version numbers here, but we're > on 7.11 of Informix and the latest CLI/I-NET (we just purchased and > received it). > > Thanks for any help you can offer, > M. Livenspargar Hi, This is supposed to be a known bug related to constraints and the naming of the indexes created automatically. They are named with a space and something like e.g. 112_1. If You create the underlying indexes and name them first and then add Your constraints it's supposed to work. I haven't tried this method myself so I can't vow for it. Cheers! -- Orjan Lindberg Naturv'rdsverket (Swedish Environmental Protection Agency) Blekholmsterrassen 36 106 48 Stockholm Tel. 08 6981282 orjan.lindberg@environ.se