October 7th, 1999, 05:20 PM
Hello Need some help here,
I am creating an application in Access 97 using VBA. I am using some built in functions , specifically DoCmd.TransferDataBase. Here's the problem If the table being linked in does not have a PrimaryKey a dialog box will prompt the user to select a key. I don't want this box to prompt the user. I want to answer the dialog box for the user. How can I do this? If I link in 10 tables then the user gets prompt with 10 windows. Also , this causes problems with automating the application.
I am creating an application in Access 97 using VBA. I am using some built in functions , specifically DoCmd.TransferDataBase. Here's the problem If the table being linked in does not have a PrimaryKey a dialog box will prompt the user to select a key. I don't want this box to prompt the user. I want to answer the dialog box for the user. How can I do this? If I link in 10 tables then the user gets prompt with 10 windows. Also , this causes problems with automating the application.