ianyates is correct.  Replication won't initially merge the data.  You have to start with a Published database which contains all of the data.

SQL Data Compare (Red GAte) is another tool which...

How important is their data?  BACKUP/RESTORE capability of Sql Server...recovery options.

you're welcome

Does a PUSH subscription from the Publisher have the same error?

run this on the publisher and subscriber:   sp_removedbreplication [ @dbname = ] 'dbname'

Double check to see if it worked by running this...

You can replicate every database, except the system databases, on any instance.  You just set them up as Publications as you did the first database.  It's the exact same procedures.

When we first started using replication we had the same error.  This is how it was resolved:

Set up a local alias on the publisher server.  This alias should be the...

if you can use Outlook 2000.  It doesn't need to be open for sql server to send mail.  Do a custom install and make "unavailable" everything except Help.

what is max server memory set at?  sp_configure

turn off "priority boost" if it's on.

We were receiving memory errors, more specifically "insufficient memory available" and had to put a MSFT call...

yes you can

You could use DTS and specify "SQL Query" in the Transform Data Task.  Then just write the query of the columns you want the data from.

Since the structure of the...

sql digger

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=112&messageid=171871

it's easy to use and highlights your search phrase

"How do I choose the country and the month a person wants and send it to the person in charge of that country?"

Create another table "ShippingRequest" with "ShipTo", "ShipFrom" and...

pogowolf is going from access to sql server, so the access table will be created in sql server; not scripted from an existing sql server table

You said you can use Enterprise Manager (web based?).  What if you FTP'd your Access database to folder on the web server that you have permissions.  Then you would be...