ADP Replication

  • Thread starter Thread starter ray
  • Start date Start date
R

ray

I have a SQL server 2000 with an adp 2002.

I am replicatig them from one city to the next on
identical servers. Using ADP as the front end.

I can replicate no problem transactional continous
updating and works fine both ways. HOWEVER, when i
connect the fe to the main db which was the one that
created the replication it works fine. But when I connect
to the other server and try to add a new record it gives
me the message (error)"The data was added to the database
but the data wont be displayed in the form because it
doesnt satisfy the criteria in the underlying record
source."

ANY ideas, this is my last obstical for going live.

Thanks

ray evans
 
That message normally implies that you have a filter on your form, and that
the data you've inserted doesn't match the filter criteria. For example, you
may only be displaying invoices with values greater than $100, and you've
inserted an invoice for $50.
 
That is what I thought however, I am looking at the
tables in the ADP and there are no filters. I have found
a unique problem to the tables that caused this problem.
The tables that cause the error have the primary key set
to the ID autonumber field.

I have for a temporty basis set the primary key to the
replication ID and it worked for a while with no errors.
However I want the primary key to be the ID number.

Thanks for the previous answer but still looking for more
info.

ray
 
Is your form's recordsource a SELECT statement like SELECT * FROM MyTable ?
I had this problem before and resolved it by using a view.
 
I have tried going straight into a view of the table and
this still doesnt work:

Main SQL Fields include:
CSR Name(primary key), CSRID (identification),Replicaiton
ID(newid())

Replicated SQL Fields:
CSR NAME(primary key), CSRID (default is set to (0),
Replication ID (newid())

If connected to the main sql sever all is ok and the ID
number comes up with autonumber before entering. Then when
i connect to the replicated sql server the CSRID number
comes up as 0 at that second but once its entered it gets
the correct in line number.

What am I doing wrong??
 
Back
Top