Recent content by DRich12

I have 2 SQL 2000 servers replicating using type merge. When I created the agents, I got the usual conflict tables. However, they have not gone away. It appears that my tables are current. My question is, can I delete these conflict tables? And how? Thanks, DR

Do you have a copy of the db before the change? If so can you open it now? If you can open the old db try to open it in the new version and let access do the conversion for you. Working from a copy of course.

Using the recordset cmd. You have the recordcount method. Ex: With rst .Movelast 'Populate the recordset .Movefirst temp = .recordcount 'This will give you the current number of records in the rst recordset. If you add or delete records you will have to call this routine again or update...

If the string length is always 6 char then use the Left(string,5) and Right(string) commands. Ex: temp = Left(string,5) & "-" & right(string,1) If the length will vary then use a for next loop to cycle through it like this. Ex: for x = 1 to len(string)-1: temp = temp & mid(string,x,1)...

I am using ACC2000 project to access data stored on SQL 2000. When I post data in to a char field (VBA Ex: charField = "A string here") using a rich text control on my form, the data is copied in triplicate into the field on the server. When I view the field it shows up as a double...