Is there a question you'd like us to answer? When you have an automatically assigned identity value as your PK, in Access you will occasionally have things happen that...

Have you tried the 'About' under Help in SSMS?

Do you have a machine at home you could use? If you are not using current versions, on current platforms, then you are at risk of getting divergent results...

Yes. That can be done. But before we repeat ourselves, why not search the forum for pre-existing answers?

Or refer to books online for the command syntax, try writing...

and, after the dust has settled, and the crisis is over, make sure that an important task is to reprogram this process to eliminate the RBAR aspect of it. ...

Nested selects will solve it. And, there are articles that give you step by step instructions, including caveats regarding performance. So, rather than reinvent the wheel, here are...

Details? for the rest of us noobies? a problem with your primary key?

1. If you are going to synchronize on a daily basis, then you are not updating both databases simultaneously.

2. I have no personal experience in DOING this, so...

You stated that the applications require 'owner' rights. Is that necessarily true, or is that developers being lazy? It seems to me that the application owns the process,...

I had to download BOL in order for the links to work. It also helped to use IE, rather than an alternate browser.

The links provided don't work for me [no direct linkage]. Can you verify/update them or give me a context where I can enter them?

It figures! in order to...

Have you tried it? with what results? please describe versions and describe whether the replication is being attempted within one network or across networks, etc.

Thank you Michael! I knew in a general way, but haven't had to look at the question in over a year, and was getting interrupted before I could do...

It depends. Will the .NET application cover your license needs or not? Will the users access the database EVER without going through the app? If you ask...

Is it worthwhile to consider the value of 'ambiguity' error or warning messages? How terrible would it be if SQL required FULLY qualified names? Would that affect portability...