I'm a little baffled here. I am trying to avoid using access to create tables. I can run a create table statement and everything works fine. I've been able to add primary keys, default values, etc, and that's worked fine. What I'm stumped on, is how do I create an input mask through sql?
I've found some comparable oracle statements and I'd think it'd look something like this.
You can use a make table query or in vb code. If the first method create the query then change the query type to make table type via Query menu in design mode (you will be prompted for table name to create). In later method, search this forum for "INSERT INTO" and you will get some great ideas.