Seems like tables in SQL Server that have a numeric name prefix (e.g. 2002_TblClient) cannot be used to create a view from? I get a 1526 error. If I rename the SQL Server table to TblClient, I am fine .. but unfortuately this is not an option for me as it is not a database I can control.

Any suggestions for a workaround?

Chet Joglekar