Control an error

[Aietoe]

Hi!

When a user access my database, the first thing that is done is the execution of a macro.

In the macro, a table is first opened and the user is asked to enter his userid and password to access the database.

Even if the user enter a wrong password, he gets a couple of error messages but can access the database anyway(read only).

What i would like to do is to catch the error message in the macro and react to it... close the application or send a message....

Thanks

Aietoe

 

[PHV]

I'm afraid you have to convert your macro to VBA code for better error handling and user interaction.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Aietoe]

I'm not much familiar with that kind of code, but thanks anyway, i'll see what i can do.

Thanks

Aietoe