[AccessD] Trim in Access 2007

Hi Michael

That's what happens when you keep small secrets for yourself ... had you posted the full SQL we would, of course, have spotted that right away(?)

/gustav

>>> mmattys at rochester.rr.com 30-11-2007 19:35 >>>
I figured out what went wrong, but I still don't like it:

The imported table name is also called CASS
The SQL I used to create the table was 
SELECT TRIM([ID]) AS ID, ... INTO CASS FROM CASS IN 'dbpath'

No error occurred in the code, but manually creating the query tells
me that TRIM([ID]) AS ID is a circular reference. It created the table
anyway, it just refused to Trim.

??

(I did not use On Error Resume Next)

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com