I am linking to a Oracle database via VB code. I am using DoCmd.TransferDatabaseLink command to link to 6 tables in a data base. Some of these tables have indexes and some do not. On the tables that do not have indexes a MS ACCESS dialog pops up to select unique record identifiers. This dialog is giving me the problem. I could use a sendkey command to hit enter to bypass the dialog and to link the next table in my list. The problem arrises when I do not know which tables have indexed fields. I want the users to have the abiltiy to add more tables to link. How do I know when to use the send key command if the dialog is displayed. Is there any property that will tell me if that dialog is displayed. Thanks in advance for any help!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
database table linking problem
- Thread starter vzjfgm
- Start date
