Search results for query: *

Try this link out. http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q190/2/12.ASP&NoWebContent=1 May be the cause of the problem. If you are using the basic edition of VB6 I am not sure if the data wizard is included. Good luck

Thanks Works a treat John

I tried this code above and I get no new table in the database. I am actually wanting to create a new table within the same database and it is just the structure that I need so the above should work. I am not getting any errors. Any ideas? to try it out I substituted the following I do not see...

I have been trying to figure out how to copy an Access database table using ADO but I have so far been un-sucessful. If it is not possible with ADo what is the best way to carry this task out. thnaks John

After the WHERE statement put a ?. the tab will then become active. John Macleod

Thanks Eli I could not get that to work correctly I kept getting some strange errors. Where do I place the code. I do not have a child Command so the Hierarchy info is not avalable. Dim strSQL as string strSQL=paste Where do I place the SQL code? Do I need to do the Grouping? But I did...