Hi Nadya,

When building a three tier app, error can occur in many places. For example, you could have issue with IIS regarding permissions or configuration problems. Also, the error could occur when connecting to the database or sending SQL statements. Syntax error are the main reason for error in the VBA middle tier code.

See if you can get the error to be redirected to you web page. For example, in perl I have a statement to send all fatal errors to the browser. If an error occurs, perl send the error message to the browser that displays the error message including the line number in which the error occurred. Maybe VBA could do this as well. Also, can you redirect error messages from MSDE to your browser or some other window. The same could be said for IIS.

If you can't redirect messages for display, you will need to know where the log files are for IIS and MSDE. A quite look-see at these logs could be very helpful in correcting your code.

LelandJ