[AccessD] Trim in Access 2007

Michael R Mattys mmattys at rochester.rr.com
Fri Nov 30 12:35:25 CST 2007


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



More information about the AccessD mailing list