Merge Replication and Dynamic Filters

Hi.
I am developing an Windows Mobile 5.0 Application for the MotoQ. It
uses merge replication and everything works fine. The DB has a
dynamic filter on it so that it only sends the data that matches the
SUSER_SNAME(). The problem arises when a user, other than the inital
user for the program, wants to login using that device.
I want to have it drop the old subscription and start a new one with
the new user. I have coded it exactly as I want it, the thing is, it
still sends data for the first user. The only way for me to use the
program with a new, different, user is to reinstall it. I highly
doubt this is the only solution...
Any ideas are greatly welcome.
Thanks,
SmP
I wish I could help you, but I am having the same trouble. I would love to
see an answer.
"smp9737@.gmail.com" wrote:

> Hi.
> I am developing an Windows Mobile 5.0 Application for the MotoQ. It
> uses merge replication and everything works fine. The DB has a
> dynamic filter on it so that it only sends the data that matches the
> SUSER_SNAME(). The problem arises when a user, other than the inital
> user for the program, wants to login using that device.
> I want to have it drop the old subscription and start a new one with
> the new user. I have coded it exactly as I want it, the thing is, it
> still sends data for the first user. The only way for me to use the
> program with a new, different, user is to reinstall it. I highly
> doubt this is the only solution...
>
> Any ideas are greatly welcome.
> Thanks,
> SmP
>