We currently have a program that uses an access database connecting using an ODBC driver.
On particular table named Expenses has a field name ExpenseNumber
We recently redesigned the way some data was stored in the database and now Expenses.ExpenseNumber can have the same information in multiple rows (we are now permitting duplicates).
I have figured out how to change this setting in access
-- Open design view of the table
-- Selecting the field
-- Change Indexed from YES (No Duplicates) to YES (Duplicates OK).
The problem is that I can not ask people to do this by hand for every database so is there a way to do the above in C++?
Access has it's own version of SQL so you can run an Alter Table query using the Constraint clause (or possibly a Create Index statement) against the database through the ODBC connection.
There's also tons of 3rd party controls for editing access databases that you can just drop in your program, to do whatever you want without writing the code for it.
