Duplicate yes

[sal21]

I Just have a tablet in access database.
I need to set the index of field named TS with:
Duplicate yes
Via vb6 naturally

My ADO con Is named CON and Just Is opened

 

[Andrzejek]

Not enough information.

Wild guess:

str = "Update SomeTable Set TS = 'Duplicate yes'"
CON.Execute str

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[combo]

My guess:
With ADOX, create index, set its properties and append to required field (

https://learn.microsoft.com/en-us/s...api/index-object-adox?view=sql-server-ver16).

combo

 

[2009luca]

tks.
But i need to set "duplicati ammessi" via Adox on field Z

https://files.engineering.com/getfi...89da-40ad-82aa-5d7d8865caeb&file=Immagine.jpg

 

[combo]

Index has boolean 'Unique' property, that can be set to True or False. In the bottom of referenced page you can find VB examples of working with Index object.

combo

 

[strongm]

Does this mean that you are done with thread222-1829532?