From: Dan Nelson Date: March 8 2002 3:58am Subject: Re: making " : " an allowable character in tables & colums List-Archive: http://lists.mysql.com/mysql/102317 Message-Id: <20020308035813.GC60918@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Mar 08), joseph.chillari@stripped said: > Dan Wrote: > > In the last episode (Mar 08), joseph.chillari@stripped said: > > > Access can do it, & I have queries in access that need to be able > > > to read the data I imported into Mysql from access. Can it be > > > done, if so how > > > > Quote the name with `backtics` > > > > http://www.mysql.com/doc/L/e/Legal_names.html > > is this the key situitated next to the number 1 on the top right hand > corner of the Keyboard, if so it's illegal in Access. Oh, I misunderstood. MyODBC should quote all the table and field names for you, I believe. What errors are you getting? -- Dan Nelson dnelson@stripped