Synchronizing Access and SQL Server

[JA]

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~

[Allen]

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~

[Damien]

Allen wrote:

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~

If you haven't got SQL 2000 yet, you won't have access to BOL, which is
where you'll want to read about replication.

Here's the link to the online version:
http://msdn.microsoft.com/library/de...server2000.asp

Damien