Damian, I don't know whether you can suppress the dialog box but the way that I handle my connection is to have the database connected as PUBLIC and only change to another identifier if the name & password are validated first.
You still need to have a table (Dummy?) that PUBLIC has access to, though. Further, I think that I am right in saying that if the database is connected as PUBLIC a failure to change to another user will not disconnect if the login fails - but you'd need to check that. In my case, I simply use 3 logins to give 3 levels of action: public is view only, there is an add & amend one then the owner for design & maintenance. It just makes me think before I try to do something stupid. Regards, Alastair. ----- Original Message ----- From: "Damian Voigt" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Tuesday, May 17, 2005 10:41 PM Subject: [RBG7-L] - Suppress Enter a new user identifier dialog box > > Is there a way to suppress the connect to database dialog box? I am > trying to create a custom login form. I am connecting to my database > with a very limited user identifier so I can ask the user for theirs > through a custom form. If the user enter the correct user identifier, > everything is fine. 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. > > Any ideas? > > Thanks > Damian >
