I compare the data. The RedGate tool did not work out and I already tried it out.

Our database environments are setup very unique.

SQL 2000 and 2005 are located in...

Judi,

Are you setup the sql transaction replication?

If yes.

There are serveral debug steps that you can try.

First, Verbose SQL Server agent logging.

http://support.microsoft.com/kb/312292

The log file will direct...

Judy,

Thanks. It resolved.

The “A1” machine did not install Microsoft access. It only has the access mdb files.

The third party software is using and generated those files.

On the "A1" computer. I created a user "abc" and assigned local administrator and replicator privilege.

Should this "abc" user have sufficient right to connect Access Database files on "A1"...

The snapshot agent did not generate any errors.

Action message displayed:

-- A snapshot of 42 articles was generated.

-- Posting snapshot command into the distribution database.

-- Buld copied snapshot data for article...

Not sure. However, it indicated completed.

The Snapshot agent’s status is completed.

The Log Reader’s latency is zero (0).

The Push agent’s latency is zero (0)

How to figure the initial snapshot...

Jeff,

Thank for the tips.

TJ

Mani,

Thanks for your kind advise. It works. 🙂

Eventually, I created the database with initial size of 10GB.

Then, I incremented the database size.

Thanks for your advise. 😛

Thanks for quick advise and reply. I will start to investigate the tables.

Thanks for your advise. It is very encouraging.

SQL 2005 looks simple from outside but inside is very very deep like an ocean.

Yes, I keep learning and never...

I customized the folders to specific location during my IIS Setup.

The folders already assigned users with specific privileges. E.g: Everyone has the READ privilege on Sharing tab and...

I tried already and it did not work. 🙂

Also, I installed cd/dvd burner softwares and it still did not work out.