Hi, I want to change the "Validation Rule" property of a filed in an access table using VB Script. Current value is "=1". I want to change it to either NULL or ">=0". Please help me...! THe following code giving me an error...! ' Establish connection strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Persist Security Info=False;" & "Data Source=" & strDest Set objConnection = CreateObject("ADODB.Connection") objConnection.Open strConnString ' Create a catalog for the database. Set cat = CreateObject("ADOX.Catalog") Set cat.ActiveConnection = objConnection ' Get the table. Set tbl = cat.Tables("App") ' Get the column. Set col = tbl.Columns("ID") ' HERE I AM GETTING AN ERROR saying "Item canot be found in the collection corresponding to the requested name or ordinal" ' Set the Description property. col.Properties("Validation Rule").Value = ">=0" Thank you, Regards, ADIDADPU
A
ADIDADPU
@ADIDADPU
Posts
-
How to change the "Validation Rule" property of a filed in a table using VBScript -
Help required in comparing an image file with a text fileFriends, I want to compare an image file which contains text with a text file. Is it possible? If so, could you please help me in achieving the same. Thank, Snu
-
How to run C# application as a web service?Hi Friendz, I developed a c# application and I want to run it as a Web Service. How could I do that? Please help me. Warm Regards, Sreenivas
-
How to display images in subitems of a listview control using <b>C#</b>?I have a list view with 3 columns and I want to display an image in 3rd column during run time. I've not find any direct method to do this, Then I approached DrawSubItem event. But I am not able to achieve my requirement as it is continuosly paiting. I think I need to go for customization. But I am new to C# and I am in need of somebody's help. Can anyone please help me in getting the solution?