did you install MDAC?, maybe you should install againt the client tools.

I don't need to filter the article's records, only the subscribers.

If you don't have a backup you can't restore the table. You should be carefull and always have a backup of your databases.

You can use a third party tool like...

Are you checking the last version of your dts package?

Sorry, I meant

ALTER TABLE TableName

Alter Column ColumnName INT

To compare data structure I create a script that uses checksum(). Cheap and easy...

While you are running the DTS, do you have any other app accesing the mdb files?

I think that it can't execute because the access files are in use.

With Alter Table.

For example:

if you create the table with

Create Table TableName

(ColumnName INT IDENTITY (1,1))

ALTER TABLE TableName

ADD ColumnName INT

Well the stored procedure is compiled on creation and the execution plan is saved in memory so usually run faster than individual sentences.

But will aso...

Can you post the code you use so we can see it?

Can you post the script with the cursor?

You can use multiple filegroups with differents .ndf files and place them in another disk to win more performance for example. Or also can create a big db in one...

I would let the stored procedure to do the logic instead of the trigger.

You shouldn't have any problems downlading the SP from internet. Try downloading it again, maybe it downloads with errors.

Is this a question about merge replication conflicts?