When I go to use an ODBC query, most of the table names are duplicated in the list. If I want to use the ODBC with ACCESS, I get a message “cannot define field more than once”.
Does anyone know what is causing this problem and how to fix it?
I have more information on this issue. For some reason, when I restored this database, it made more tables that I do not have access to.
The table numbers start with 1000000003, Payment Terms Code. ie the table number with a preceeding 1000000. I do not know how to get rid of these extra tables. Can anyone help me?
That means that your restore process was interrupted, it did not finish. When you complete the restore process, it will automatically remove those tables.
WOW, that was easy. I just clicked restore and it asked me to finish. It went for about 1 second then everything was okay. I do not know what did not finish. I guess the deletion of those tables.
Thanks.