Posted by JA on 09/14/06 20:41

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~

• Next in forum: Can I avoid temp tables, etc.
• Prev in forum: sql server i/o bottle neck ?
• Thread view: Synchronizing Access and SQL Server

[Reply to this message]