I have a .mdb Access database, which contains several tables. Say it is C:\Test.mdb with Tables 100, 101 and 102

How can I achieve the following by VB6 code at runtime :

1. Delete an existing table.
2. Create a new table of, say, 20 fields specifying what sort of fields they are, give it a new table name (eg. Table103) and enter it into the database.
3. Copy an existing Table of the database back into the database but give it a new Table name.

I have spent a lot of time reading forum FAQ and MS Articles on this topic, but all the code I have tried has resulted in various errors.

Could anyone please give me some straightforward code which will work and from which I can go on to develope a solution? Right now I just can not seem to get started. Yet it seems a fairly simple set of problems.

camoore

Wales, UK