Hi all.
I'm tying to manually link tables via an ODBC link, however when I createa manual link the "_" between words is dissapearing. this means that any table names with multiple words separated by and _ won't link, and any single table names will. It is the same with field names. The form has been built with a control source of Address_1, but since i've done a manual re-link the new field name is Address 1. - There are far too many table and forms for me to think about re-naming them.
This is a database that I didn't write,and I know there is some code in there somewhere to programatically re-link the tables, but I can't find it, or work out how to make it run.
This is a database which is has some local tables and then some tables stored in Microsoft Navision. The initial database has been created and linked to 1 company in Navision. I have then duplicated the database and am trying to link the second version to the 2nd Company. this means I have 2 system ODBC links. - Could this have anything to do with it.
I hope that makes sense. Dealing with ODBC links and this level of coding is fairly new to me.
If anyone can offer any suggestions of fixing this, I'd be grateful
Thanks very much
I'm tying to manually link tables via an ODBC link, however when I createa manual link the "_" between words is dissapearing. this means that any table names with multiple words separated by and _ won't link, and any single table names will. It is the same with field names. The form has been built with a control source of Address_1, but since i've done a manual re-link the new field name is Address 1. - There are far too many table and forms for me to think about re-naming them.
This is a database that I didn't write,and I know there is some code in there somewhere to programatically re-link the tables, but I can't find it, or work out how to make it run.
This is a database which is has some local tables and then some tables stored in Microsoft Navision. The initial database has been created and linked to 1 company in Navision. I have then duplicated the database and am trying to link the second version to the 2nd Company. this means I have 2 system ODBC links. - Could this have anything to do with it.
I hope that makes sense. Dealing with ODBC links and this level of coding is fairly new to me.
If anyone can offer any suggestions of fixing this, I'd be grateful
Thanks very much