Using DAO Replication Services with several filter conditions

[natxito]

I have made a partial replication of an Access 97 Database (Microsoft Jet Engine 3.0), and I am trying to filter some tables of the original database. There is no problem when I use only on condition...
ex: tabledef.ReplicaFilter = "Code = 1"

but the problem comes when I need more than one condition.
ex: tabledef.ReplicaFilter = "Code = " and the code must be 1,3,5 and 8, for example. I have tried these solutions what they don´t work at all.

ex: tabledef.ReplicaFilter = "Code in (1,3,5,8)"
ex: tabledef.ReplicaFilter = "Code = 1 or code = 3 or code = 5 or code = 8"

I will continue trying it... If someone has any idea of how doing this... please tell. Thanks for all.

Natxo - Spain

 

[natxito]

I got it!!!

Look at this:

tabledef.ReplicaFilter = "[cod] = 1 or [cod] = 3 or [cod] = 5 or [cod] = 8"

Microsoft is fantastic!!... I love it!.

(I am a MCP and next month MCSD... ;-))