Forum Discussion

YLMike92887's avatar
YLMike92887
Copper Contributor
Jul 23, 2024

DDL Syntax

I am attempting to use the following DDL statement from within Access:   ALTER TABLE MyTableName ADD CONSTRAINT NOT NULL ( MyFieldName1, MyFieldName2 )   and I get a syntax error.  Can someone pl...
access
developer
Karl_Donaubauer's avatar
Karl_Donaubauer
MVP
Jul 24, 2024

Hi,

 

> ALTER TABLE MyTableName ADD CONSTRAINT Check ( ( MyfieldName > 0 ) AND ( MyFieldName < 3500 ) )

 

1. You have to specify a name for the constraint.

2. You have to use ADO to add a Check constraint.

 

The VBA code could look like this:

CurrentProject.Connection.Execute "ALTER TABLE MyTableName ADD CONSTRAINT myConstraintName Check ( ( MyfieldName > 0 ) AND ( MyfieldName < 3500 ) )"

 

Servus
Karl
****************
Access News, Forever, DevCon
Access-Entwickler-Konferenz AEK - 19./20.10. Nürnberg

 

YLMike92887's avatar
YLMike92887
Copper Contributor
Jul 24, 2024
Hi Karl --

Thanks for your reply.

I had a name for my constraint. I was sloppy about not including it. Sorry about that.

Thanks for your input on this type of constraint requiring the use of ADO. Is there a reference somewhere about what things require ADO? It would be nice to know this kind of thing.

Thanks again!

Mike

Resources