>>I believe you can do this with ADOX.
>
>Only if the database supports it. As of ADO 2.5, Access is the only database that fully supports ADOX.
True. I guess I should have said that SQL Server and Oracle support the reading of the Keys collection. I know you can't add or delete keys via ADOX in SQL Server or Oracle. And if he meant VFP, I really don't know. I've never tried it with VFP databases.
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
