Synchronizing Access and SQL Server -- sql server (alternate)

Allen
9/14/2006 5:57:11 PM

Hi,

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

Regards,
Allen

[quoted text, click to view]

JA
9/14/2006 8:41:03 PM

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
9/15/2006 12:22:23 AM

[quoted text, click to view]

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/default.asp?url=/library/en-us/dnanchor/html/sqlserver2000.asp

Damien

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server (alternate)

sql server (alternate) : Synchronizing Access and SQL Server