>Well if the debug.print .source outputs SELECT * FROM user and not select * from SELECT * FROM user and your connection is open to a database with the table user, then I am stumped. It is probably somewhere else in your code if it was working before. If you have some other code that goes with your with statement that you can share it might help, but from what I can see I am truly out of Ideas.

Yes it is
(SELECT * FROM user
1 )

the code fist goes to this eara.
anyway, thank u very much for you help.