Hi. I recently got into some trouble with my CDaoDatabase programming. I can't access multiple databases in SQL. The fact is when I use pdc->Execute("SELECT * INTO db2..newtbl FROM [existing_table]"), SQL doesn't recognize db2..newtbl as a new table in database db2. The trouble is that I don't know how to refer to a database i've already opened in an SQL command. I'll appreciate your help if you can help me.