#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    29
    Rep Power
    0

    DDL Problem: Table ID is invalid


    I'm trying to create a table in a new Access database, but the line in the code that says

    catDB.Tables.Append tblNew

    provokes this error:

    Microsoft JET Database Engine error '80040e3c'
    Table ID is invalid.

    Could this be a permissions problem? It's a brand-new hosting account, brand-new directories, etc. The DDL code that created the database ran successfully, but now I can't create a table in that database.

    Any thoughts?

    Thanks,

    Charlie

    Comments on this post

    • JimmyGosling agrees
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    For clarification you have a hosted account that where you are using MS Access as the backend database and you are unable to create a table?
    ...
    Okay ... can you please post the DDL you are using to create the table?
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    29
    Rep Power
    0

    Fixed It!!


    It turns out that's the error message you get when you forget to assign a name to the table, ie

    tblNew.Name = "MyNewTable"

    Who knew?... ;-)

    Charlie

    Comments on this post

    • JimmyGosling agrees

IMN logo majestic logo spyfu logo threadwatch logo seochat tools logo