Hey all you gurus out there! This is probably something easy, but I am
having a mind block!
We have a SQL database (6.5) hosted on a remote server that we access
with SQL tools for Access 97. When the tables were set up, one of our
fields, "email", was set as a indexed field with NO duplicates. Is
there any way to turn this off and NOT index it (as to allow
duplicates)? On the other side, is there any way to take one that is
NOT indexed now and index it for NO duplicates?
We try to do this, and we change the setting, but it just goes back to
its old one 1 second after we change it automatically. It has me
baffeled. Please give me all scenarios that you can think of.
Please respond back via posting, so all may see your answer.
Gundersen Lutheran Information Systems
Sent via Deja.com http://www.deja.com/
Before you buy.