Re: MS ACCESS <-> DSA

Joe, The most common problem I have had is MSAccess does not like indexe names created by informix that begin with a space. This happens when you creat primary keys, foreign keys or constraints. Access needs a uniqe index with a name that begins with an alpha character to lock a row for updates and deletes. To get a database to work with Access this is what I do: - drop all constraints, primary keys .... - creat one unique index with a valid "Access" name on each table - re-create constraints .... They will use the exiting indexes. Regards - Lester > Joe Lumbley(jlumbley@netcom.com) said: > How about a quick pointer to something I remember seeing here? > altavista and iiug searches don't find this. > > Someone wrote about & solved a problem about connecting MSACCESS to 7.xx. > Problem was a problem with inserts/updates (I believe). The answer had > to do with the need to have a unique index on the tables. At the time > I saw it I wasn't interested in Access...now one of my cohorts has a > similar problem and I'd appreciate a pointer to the original article thread. > TIA. > ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # # Visit our Web page: http://www.access.digex.net/~lester # # Washington Area Informix User Group: http://www.access.digex.net/~waiug # #############################################################################