Re: MS Access -> ODBC -> OnLine 5.0

In article <4cte7e$mor@cssun.mathcs.emory.edu> dpp@dmr.co.uk (Dominic Pratt) writes: >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 >} >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 > Yes - in Access close any attached tables, select the table and choose Rename from the File menu to enter the new name. -- Keith Davies Internet: keith@keithd.demon.co.uk Tel.: +44 1582 833651