Edit design table in eplication

[Guest]

I'm using SQL Server 2000 for BE, and msaccess 2003 as FE. I have problem
when I tried to edit design tables in the database which being replicated,
the error message is :
Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop
the table 'dbo.tbl_TPS' because it is being used for replication.

I have already knew how to add/drop columns, but I can't edit the existing
column in the database.

Is there anyone can help me....?

 

[Sylvain Lafontaine]

Making changes to the design of a database which is being replicated is a
very complicated matter and cannot be done from ADP. As a start, you can
consult the following article:

http://www.replicationanswers.com/AddColumn.asp

and see the m.p.sqlserver.replication newsgroup as well.

A word of caution: is this database is used for real in a production
environment, make sure that you understand exactly what you are doing before
beginning these steps.

 

[Guest]

Thanks for the links... I forgot to mentioned that I use merge publications,
and that site contain information about snapshot publication, but I've
adjusted the
stored procedure to works in merge publication, but somehow... still didn't
worked. I'm still trying to work on it......

Yes I heard about the caution words, and I understood it right now.

Making changes to the design of a database which is being replicated is a
very complicated matter and cannot be done from ADP. As a start, you can
consult the following article:

http://www.replicationanswers.com/AddColumn.asp

and see the m.p.sqlserver.replication newsgroup as well.

A word of caution: is this database is used for real in a production
environment, make sure that you understand exactly what you are doing before
beginning these steps.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

I'm using SQL Server 2000 for BE, and msaccess 2003 as FE. I have problem
when I tried to edit design tables in the database which being replicated,
the error message is :
Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop
the table 'dbo.tbl_TPS' because it is being used for replication.

I have already knew how to add/drop columns, but I can't edit the existing
column in the database.

Is there anyone can help me....?