My Assistant
Site Message
(Message will auto close in 2 seconds)
 Removing The 'required'/not Null Restriction Using Vba, Office 2003
|
|
 Sep 14 2011, 06:26 AM
Post
#1
|
|
|
UtterAccess Addict Posts: 293  |
Hi, I am trying to use the ALTER TABLE, ALTER COLUMN command in vba to set required=no of an existing table but can't figure out how to do it.
Here is the code I currently have. What needs to go inplace of ....? Thanks CODE Dim cnn As New ADODB.Connection
LinkPathFile = Mid(FindSource(), 11) With cnn .Open "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & LinkPathFile .Execute "ALTER TABLE tblRequests ALTER COLUMN RequestFee ....." .Close End With |
 |
 
|
 |
Replies
|
Sep 14 2011, 11:51 AM
Post
#2
|
|
|
Retired Moderator Posts: 19,667 |
Sorry... I was thinking of T-SQL.
I normally use DAO Field Object to alter the Required Property of the JET Table Field istead of ADO + JET DDL. An alternative is to use ADOX. See UA Topic Code Library Form with lst/cbo RowSource pointing to FE and follow the links to the 2 MSDN articles posted by Brent for more info. |
|
|
|
Posts in this topic
ddaddy Removing The 'required'/not Null Restriction Using Vba Sep 14 2011, 06:26 AM
vtd Try NULL in place of .... Sep 14 2011, 10:56 AM ddaddy I've tried that, I get Syntax Error in field d... Sep 14 2011, 11:09 AM ddaddy Thanks for the link. I've read that and will u... Sep 14 2011, 12:18 PM vtd Check Access VBA/DAO Help on the Required Property... Sep 14 2011, 12:38 PM ddaddy Had to make add some more code as i'm using a ... Sep 14 2011, 01:37 PM vtd You're welcome... Glad to help... Sep 14 2011, 08:33 PM
Darwood QUOTE (ddaddy @ Sep 14 2011, 06:37 PM) Ha... Jan 10 2013, 07:00 AM |
 |
Jump To Forum:
|
Go to Top · Lo-Fi Version | Time is now: 23rd May 2013 - 04:04 AM |