Hello,
I'm trying to create a table using the CREATE TABLE command (in Access 2000) and I'm having great difficulty. First off, I need to say that any solution must be ADO, not DAO. Here's the statement I'm using...
This is straight out of the Access 2000 Developer's Handbook, yet it gives a compile error. I don't see what is wrong with the statement, but I'm new to Access... (so go easy on me).VB Code:
CREATE TABLE tblFoundItems (ModelNumber TEXT, FxCap TEXT, FyCap TEXT, _ FzCap TEXT, MxCap TEXT, MyCap TEXT, MxCap TEXT);![]()
Thanks




Reply With Quote