Updating more than 2000 records in access

[Abdolhosein Vakilzadeh Ebrahimi]

Hi:

I need to update more than 2000 items in my application.
But this takes lot of time.
I tried transactions but no difference.
What is the best way to bulk update the DB?

Thanks

[Herbert Chan]

Using the SQL UPDATE statement I suppose.

Herbert

"Abdolhosein Vakilzadeh Ebrahimi" <va********@kzlabs.com> ¦b¶l¥ó
news:b9**************************@posting.google.c om ¤¤¼¶¼g...

Hi:

I need to update more than 2000 items in my application.
But this takes lot of time.
I tried transactions but no difference.
What is the best way to bulk update the DB?

Thanks

[MeadeR]

Updating 2000 records via SQL should be quick - depending on how
complex the update is....can you provide more info regarding the type
of update and how you're performing now...

va********@kzlabs.com (Abdolhosein Vakilzadeh Ebrahimi) wrote in message news:<b9**************************@posting.google. com>...

Hi:

I need to update more than 2000 items in my application.
But this takes lot of time.
I tried transactions but no difference.
What is the best way to bulk update the DB?

Thanks