Posted by Allen on 09/15/06 00:57

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~

• Next in forum: Line Break in T-SQL
• Prev in forum: Actual and Estimated Rows
• Thread view: Re: Synchronizing Access and SQL Server

[Reply to this message]