>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.
>
>Thanks.

What Access version are you using? sounds like you're on Acc2000 and using MSDE as the database (or intend to).