two questions about replication IDs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two questions about replication IDs

1) is it ok to use rep IDs as keys to join tables (i.e. does it choke or
does it take up way too much memory, etc)

2) i want to reset a form's recordsource with VBA. When I use the procedure
below with a replication ID it returns nothing but if I use a text field it
works fine. I am assuming the rep ID number itself is the problem. If so, is
there a way around this?

Please help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

'shows only those records in the "sample" table with a link_table_id same as
the one on the open record
Private Sub Command122_Click()
Dim strNewRecord As String
strNewRecord = "SELECT * FROM sample " _
& " WHERE link_table_id = '" _
& Me!link_table_id.Value & "'"
Me.RecordSource = strNewRecord

End Sub
 
Thanks brendan, that answered my question!!!!!!
Basically I should not use them as a primary key. However, the article did
not say what I should use. On one hand MS says if you are going to
synchronize over 100 new records to use the rep ID but this article (and
others I have read) say that this is not a great idea. But no one is saying
what to do!!!

Do you have any recommendations on what to use as a primary key if there are
going to be lots of records and over 100 new records during
synchronization.????????

Many thanks for your help, and time!!
 
Replication is a specialised area, and not one in which I have personal
experience. I'd suggest asking the question in the replication newsgroup -
microsoft.public.access.replication
 
Many thanks, will give it a try!!




Brendan Reynolds said:
Replication is a specialised area, and not one in which I have personal
experience. I'd suggest asking the question in the replication newsgroup -
microsoft.public.access.replication
Click to expand...
 
Back
Top