instead of using

doCmd.RunSQL strSQL

use

CurrentDb.Execute strSQL, dbFailOnError

why are you making a bunch of tables as opposed to using
select queries?

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

yaniv d wrote:
> hi all,
> i built SQL sentences that are making tables dinamicly,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11232-sql-sentence-for-make-table.html
> my problem is that everytime a table is going to be made,the is a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11232
> message asking for approval of the make table.
> how can i make the table without this message?
>