Re: MS Access -> ODBC -> OnLine 5.0
Posted in 1996
At 12:36 am 09/01/96 GMT, you wrote: }While in MS Access, whenever I perform the "Attach table" menu }option, the tables show up in the format } }creator_name.table_name. Whenever I choose one of the tables, it }gets added to my Access db in the form }creator_name_table_name. This causes much wailing and gnashing }of teeth for my developers, because they're used to using just }the table_name and many things will have to be changed to }implement this. This does not happen when attaching to the }tables using other means, such as VB. } }Anyone know how to get rid of this? I'm using the ODBC driver }from Informix (which I understand comes from Visigenics). } It is a feature of Access's Attach Table function and not the ODBC driver. Can you not rename the table after the attachment to remove the prefix? Dominic Pratt