This is probably a simple fix for anyone who knows more about this than I (and that is probably most).
The code below always does the finally part of this try catch block and doesn't appear to do the lines within Catch. What do I have coded wrong or what do I need to change to get this to work.
I get this message. The table 'tblEmployees' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
I'm getting this since I have the table open in Access on purpose to throw the error to test the try catch block.
Catch ex As Exception
txtSqlString.Visible = True
strErrorMessage = "error getting data. Exception was " & ex.ToString
txtSqlString.Text = strErrorMessage
rstemp = objConnection.execute(strSqlCommand)
GetRecordSet = rstemp