I have an application that transfers data between an access database and a SQL server database. I am trying to copy the data from tables that I think are exactly alike with the same tables and same fields. I am having to add new fields at times and this is where the problem is. Some of the users access database is out of sync with the SQL database.
I have tried cycling through all of the definitions on each and before I make the attempt to transfer, I take the name of the field and display it on a form. But I am getting a value that crashes my program. I am looking for a way to programmatically compare an Access table to the SQL table inside of my SQL server...
Thanks in advance for any ideas.