Add () so that the DB Engine recognizes the item as a function and not a field name.
Select * INTO tmpTable In Get_TempMDB() From thisTable ;
If that doesn't work, how about dynamically writing the query - you create a new query or edit an existing one in code, and edit it's SQL property to your desired SQL statement. Better yet - don't bother with the query - run the SQL directly using DoCmd.RunSQL
Thank you agian for your idea, one can make such a function, but I have to make a lot of changes in the porgram, so I let this as a last solution or I can use a constant name for the IN part
Select * INTO table name IN 'constantFileName'
Thanks again and merry christmas