I have a form where most of the users will simply fill out the form and send it to a central location where the form gets reviewed and then submitted to a database through ODBC data connections. The problem is that the users that fill the form out don't have and don't need the database that the form connects to. So, when they open the form, the form will not be able to find the ODBC connection the data connection refers to and they get the "connect operation failed..." message.
Is there a way to suppress this message?
Another option would be to have a button that does the data connections at runtime that the people at the central office could press, but I haven't been able to find a way to do this either.