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
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?
It turns out that's the error message you get when you forget to assign a name to the table, ie