Use Transaction property

[rKp]

I have a db that I make several data manipulations on (delete, insert,
updates, etc). The database is large ( > 1GB) and I constantly make updates
to tables that contain over a million rows. I have modified the
maxlocksperfile setting to 200,000 but I still get errors. I read somewhere
that I can set the Use Transaction property of a query to No and that will
not capture transactions for rollback and hence not require as much
processing power or disk space.

Is this correct? And if yes, will there be a performance impact? My queries
take over 15 minutes to execute.

I am using Access 2003, with Access 2000 format. Windows XP

 

[[MVP] S.Clark]

The Help file says kinda the same thing. Did you try it?

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting

 

[rKp]

Yes, I have tried it; with no perceptible improvement in performance.

Oh well.

Are there any known issues with setting this property to No (other than that
I cannot rollback, which isnt a significant issue for my application).

Thanks in advance.