Change field properties after creating the table (using SQL or VBA)
Changing the value from No Duplicates to Duplicates OK should not cause a
problem(Hopefully you see that the opposite would not be true.)
Backup the table
Open the table in design view
Change the property
Save the table
--
Steve Clark, Access MVP
www.FMSInc.com
Quote:
> Thank you for your help
> I have created table ((Passengers)) with field PassportNumber ((data type
> (text), indexed=yes no duplicate)
> I want to change the properties of this field PassportNumber TO (Yes
> (Duplicates OK))
> Note:
> The table now contain passengers data (4000) record.
> Or can I use VBA to do this.
> Thank you
