Filter Problem with Populate partial

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Zepo via AccessMonster.com (forum_at_AccessMonster.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 12:27:36 GMT

I 've got always the same problem :
 My procedures goes well until the populatepartial method which displays an error filter message.

My code is the classical one, what's wrong in it :
Function intRepAdd(strRepDB As String, strNewRep As String) As Integer
    Dim dbsTemp As Database
    Dim tdfCLI As TableDef
        
Set dbsTemp = OpenDatabase(strRepDB)
dbsTemp.MakeReplica strNewRep, "Replica of " & strRepDB, dbRepMakePartial
dbsTemp.Close

Set dbsTemp = OpenDatabase(strNewRep, True)
Set tdfCLI = dbsTemp.TableDefs("TAB_CLI")
tdfCLI.ReplicaFilter = "[N_TC] = '1'"

dbsTemp.PopulatePartial strRepDB
dbsTemp.Close
intRepAdd = 0

Thanks a lot 

-- 
Message posted via http://www.accessmonster.com