> Is there a way to suppress the connect to database dialog box? > If the user enters the wrong user identifier, when > I issue the connect statement the message -ERROR- The current user > identifier will not allow access to any table. (2318). I can turn the > error message off. What I want to do is suppress the dialog box that > follows so that I can present my form again.
Create a simple, empty table, and grant SELECT on it to PUBLIC. Now, when you connect with the bad user ID (or do SET USER) you will not generate the message. Once you connect, do a SELECT against another table (not granted to PUBLIC) to determine if you are "really" in the database, or just connected with some random user ID with only PUBLIC rights. -- Larry
