You can do it by creating a TableDef object...but that's gonna be a bitch because this is DAO stuff and you won't be able to set all the properties of the new table as they are in the template.

You could also try:

oAcc=create("access.application")
oAcc.DoCmd.CopyObject("C:\test\mydatabase.mdb","3-2001-info",0,"general_info")

This might work....but I keep getting an error about not being able to perform the action at this time but that may only be because my settings in Access 2000 here are non-standard.


>Hi. To make a long story short, I need to create Access 2000 tables and insert them into a .mdb database with VFP 6.0. Template tables reside in this database that I can utilize. For example, when the first record is entered for March, 2001 it will create the table [3-2001-info] from the template table [general_info]. I have disovered how to insert data into an Access database, but I can't find how to create one. If anyone has any ideas, please let me know.
>
>Thanks in advance,
>Steve