Re: Best way to update a record

hello everybody..

in here..i want to ask about the FileSystemObject method. Because i've got a
reply to backup my database, using FSO method is the best way. But the
question is, how could i do that? Because i never been use that method. So,
i'm appriciate that if someone could give some suggestion or website that
includes any tutorial about FSO.

I hope from you all. Thank you in advance..

"Val Mazur (MVP)" wrote:

> Hi
>
> Using UPDATE statement will save you time, because application will not
> spend time to open cursor as in a case of server-side case. In a case if you
> need to make some action (insert, update or delete) it is always more
> efficient to use an actual INSERT/UPDATE/DELETE statements
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "smk23" <smk23@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:0C4625B6-4492-4EA8-B466-5A0046CA0DED@xxxxxxxxxxxxxxxx
> > If I want to update a record in a SQL table (MS Access FE), is the most
> > efficient method to create a server-side cursor and use the ADO update
> > method, or simply write an UPDate SQL statement?
> >
> > TIA
> > --
> > sam
>
>
>
.