Creating a new table in code

[roger_anderson]

I'm a newby to VBA. I have tried to create a new table from within a module following the code in the help file. I get a compile error "User-defined type not defined" to the code Dim dbs As Database. Where should I be defining what?

 

[Jack Cowley]

If you are using Access2000 then you will need to use ADO code or dimension your code using DAO.

Dim dbs As DAO.Database

You will also need to open any code page and select Tools > References and find 'Microsoft DAO 3.6 Object Library' and check it.