The ShortDatePattern does not specify the date separator, so when you use a pattern from a culture other than the current culture, the separator will still be taken from the current culture. Use the CultureInfo object or DateTimeFormat object to format the date instead. They also contain information about the date separator. --- b { font-weight: normal; }

Dim greeky As Boolean = True Dim xDs1 As New DataSet Dim xDs2 As New DataSet For i As Short = 0 To xDs2.Tables(1).Rows.Count - 1 greeky = greeky And xDs1.Tables(0).Rows.Contains(xDs2.Tables(1).Rows(i)) Next If greeky Then MessageBox.Show("xDs1.Tables(0) contains all rows of xDs2.Tables(1)") End If

I'm just learning all this myself and I would have to compare each column in the rows. Maybe someone else knows of a compare method. A new thread with that question as the topic might get more notice, either here or under the language you are using.

Yes, replication is about the only way your going to accomplish this. You can either use the Replication facilities built into Access or use a 3rd party utility to do it, or come up with your own scheme and code. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome