Post reply

Create Table using VB and DAO

  • April 14, 2005 at 3:00 pm

    #164082

    I am trying to creat a table from Visual Basic using DAO. My SQL command is "create table test (testfield char(5) not null)"

    This works fine when I connect with ADO but using DAO I get message 3032 Can't perform this operation.

    Once the table exists I can use it succesfully with Select and Insert statements using DAO.

    Kees

  • April 15, 2005 at 7:36 am

    #552908

    You may want to use the CreateTableDef Method.  There is a good example in ACCESS Help. 

  • April 17, 2005 at 4:24 pm

    #553064

    That works fine, thank you very much!  Kees

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply