Open Linked SQL Express Table In VBA

The following problem is in Access 2003 as front end and SQL Server Express holding the data.
I have about 50 tables in Access linked to the SSE.
When I try to open and work with the linked tables using the following code, some of the table works fine and other give error 3622.
********************************************
Dim Tab1 As Recordset, DB1 As Database, SQL1 As String
Set DB1 = CurrentDb
SQL1 = "SELECT * FROM Any_Table"
Set Tab1 = DB1.OpenRecordset(SQL1, DB_OPEN_DYNASET)
do the required work with Any_Table
Tab1.Close: Set DB1 = Nothing
********************************************
I can not figure out why some table open fine and some give error.
If I use ADO all tables will open without problem but it works much slower then the code above.

I appreciate any help.
Thanks

I just got the solution from another forum, a dbSeeChanges option must be added to the open statment.
Hope it may help someone, this issue is solved.