> > Folks > > In this, admittedly unusual, situation the above occurs: > OS: Win2K > Perl: V 5.8.0 > DBI: V 1.32 > ODBC: 1.01 > DSN: Points to a Microsoft Access database > Table name: Nathan Bailey (note the single space) > > If I do: > select * from `Nathan Bailey` > it works. Yes, they are backticks. > If I do > select col_a, col_b from `Nathan Bailey` > I get: > Describe failed during DBI::st=HASH(0x1c9f0b8)->FETCH(ParamValues) > > This problem does not arise with other 'funny' table names, eg: > `Display_ISDT_210_&_Digital` (note the &). >
Ron, Can you send me a small sample database directly? I'll look at it. In the mean time, try putting [] around the table name. Regards, Jeff