Re: Synchronizing Access and SQL Server

Hi,

Yes. You are right. It's called Replication. It can solve your problem.

Regards,
Allen


JA wrote:
Hi,

Is it possible to make changes to an Access 2000 database on my desktop, and
have it update those changes to SQL Server 2000 on the web?

I have to update stock and prices every night. Right now I am using Access
2000, and I just make the changes, and then upload the changed db to the
server, and overwrite the old db.

But I am going to be using SQL Server 2000 soon, and I know you don't just
overwrite the db each time.

There are about 6 fields that *might* change each night, per record.

Is it called replication? How (basically) do I go about it? Are there
programs out there that will make it easier?

Thanks for any advice!

J~

.

Relevant Pages

  • Re: Synchronizing Access and SQL Server
    ... It's called Replication. ... I have to update stock and prices every night. ... and overwrite the old db. ... But I am going to be using SQL Server 2000 soon, and I know you don't just ...
    (comp.databases.ms-sqlserver)
  • Synchronizing Access and SQL Server
    ... Is it possible to make changes to an Access 2000 database on my desktop, ... and overwrite the old db. ... But I am going to be using SQL Server 2000 soon, and I know you don't just ... Is it called replication? ...
    (comp.databases.ms-sqlserver)
  • Re: Transactional replication from SQL Server 2005 to SQL Server 7 - how?
    ... SQL Server 7.0 from the SQL2005 management tools but I would encourage to ... primary keys are replicated as unique indexes if you ... configure replication using the SQL2000 Enterprise Manager. ... If you plan to reinitialize your SQL2000->SQL2005 subscription in the ...
    (microsoft.public.sqlserver.replication)
  • Re: High Availability
    ... also does failover. ... Async replication is real-time, as opposed to the scheduled Log Shipping ... > Note that one of the considerations for the active/passive GEO Cluster is ... > SQL Server 2000 High Availability Series ...
    (microsoft.public.sqlserver.clustering)
  • Re: Snapshot Creation
    ... Director of Text Mining and Database Strategy ... Looking for a SQL Server replication book? ... The Microsoft AD account under which the Snapshot agent (and other ...
    (microsoft.public.sqlserver.replication)