Can you humour me here and just try this simple code on another button.

Dim rs As Object, SQL As String
on error goto errorcatch
SQL = "SELECT  tblEmployees.* " & _
"FROM  tblEmployees "
Set rs = CurrentDb.OpenRecordset(SQL)

exit sub
errorcatch:
MsgBox "Error #: " & Err.Number & vbCrLf & vbCrLf & Err.Description


You may have to remove the space after tblEmployees in the From statement.

Let me know if that works without an error.