>Thanks Larry.
>
>But if access can do this by menus and modifying relationship, I think it could be done programmatically, I'll look into access help, I hope to find this because I need it to upgrade many databases.
>
>Another idea to upgrade the databases is creating with acces a new database with all changes made with access and only copy all the table's records to the new database, but this process takes a lot of time, it's faster modifying only some tables and relationship programmaticaly.
>
>If you have another idea, please tell me.
In the VB help file, take a look at "DAO, creating relationships".
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com