Wendel,

thanks I was able to create the odbc in the user dsn. I was trying to create it via the export part of external data but I realized i needed to do so through the import odbc. Then I was able to choose the tables that are part of the database and now I am able to update the records. Thanks for your input.

I'll have to look into integrated security though. For now I just set up a single user account as my team is only 3 users.