|
|
Posted by Damien on 09/15/06 07:22
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/default.asp?url=/library/en-us/dnanchor/html/sqlserver2000.asp
Damien
Navigation:
[Reply to this message]
|