1. Performance, 2. Rollback

  • Thread starter Thread starter jokobe
  • Start date Start date
J

jokobe

hi ng,

have two big problems:
1. The GUI for a ACC 2000 Database is on the client,
whereas the data are stored in in a separate database on
our server. This solution is pretty slow, for example:
opening a popup takes 11 secs, the popup is reading with
dcount and dmax two tables, one table is empty, the other
table contains 1 record.
Is there a way to enhance performance?
2. Trying to use the BEGINTRANS and ROLLBACK command, but,
alas I'm not very successful. Have started a transaction
WS.BEGINTRANS trhrough a global procedure when opening
the form, but the data are stored in the table when using
WS.ROLLBACK on closing the form?
What's wrong with my code or idea?

thanks in advance for any helpful hint

jokobe
 
1. Performance
See Tony Toews' Perforance FAQ at:
http://www.granite.ab.ca/access/performancefaq.htm
You should get a really significant difference by turning off Name
AutoCorrect and subdatasheets, and keeping the network path < 128 char.

2. Transaction
Bound forms have their own transactions which are not exposed, so you cannot
wrap them in your own custom transaction as well.

In recent versions, you can open a transaction, open a recordset within the
transaction, and then set the Recordset property of the form to the
recordset you opened programmatically, which effectively gets it inside your
transaction. Naturally you have to give your recordset variable a lifetime
at least as long as that of the form. Our experiments with this approach
found that it was a bit dicey (unstable), and that it was not possible to
wrap a form and its subform in the transaction (due to the way subforms
reload records whenever the main form changes), so is of limited usefulness.
 
In recent versions, you can open a transaction, open a recordset within
the

And in older versions, forms WERE in the default workspace.
Just another optimisation to make Access work better...

(david)
 
Back
Top