Replies

Thats a good idea, I’ll bear it in mind.

Thats a good idea, I’ll bear it in mind.

A thousand thanks.

(I feel a right idiot for not spotting that)

A thousand thanks.

(I feel a right idiot for not spotting that)

Runtime error 2793

I have the code in the Form_Current event (and no other code at all)

Runtime error 2793

I have the code in the Form_Current event (and no other code at all)

Thanks Hans.
Thats what I tried without success. When I changed the record it didn’t update the doc. Do I need to force some event in the object?

Thanks Hans.
Thats what I tried without success. When I changed the record it didn’t update the doc. Do I need to force some event in the object?

Thanks to all who have responded.

There isn’t much more I can optimise in the FE wrt. forms. Basically the ‘normal’ user just gets one form (with 4 sub forms) and then a simple print menu when they click a button.

If you are interested it is example 1 on my home page. http://www.ainscow.ch

The admin gets a different set of options but that is really just for control purposes.

There isn’t much more I can optimise in the FE wrt. forms. Basically the ‘normal’ user just gets one form (with 4 sub forms) and then a simple print menu when they click a button.

If you are interested it is example 1 on my home page. http://www.ainscow.ch

The admin gets a different set of options but that is really just for control purposes.

Thanks – i’ve worked throught the list – those that I can influence.
I’ve forced a connection to be permanent (bound form), checked things are turned off, replaced custom functions in queries (one) and changed dlookup/dmax to custom functions using recordsets.
Starting for the second and other users is now acceptable (not as fast as with Access 97 but only 3-4 seconds).
Using the interface doesn’t seem to be any faster than before the changes. It’s slower than Access 97 (ca 1 second where it took say 0.5 seconds) but it is usable.

Thanks – i’ve worked throught the list – those that I can influence.
I’ve forced a connection to be permanent (bound form), checked things are turned off, replaced custom functions in queries (one) and changed dlookup/dmax to custom functions using recordsets.
Starting for the second and other users is now acceptable (not as fast as with Access 97 but only 3-4 seconds).
Using the interface doesn’t seem to be any faster than before the changes. It’s slower than Access 97 (ca 1 second where it took say 0.5 seconds) but it is usable.

Network ‘should’ be OK. It worked fine for the Access 97 version on the old server. No hardware changes to switch/cables has been made, just new server/OP system, various patches installed and some changes (grrr..) on the local machines re user rights.

I’ll check the link out.

Network ‘should’ be OK. It worked fine for the Access 97 version on the old server. No hardware changes to switch/cables has been made, just new server/OP system, various patches installed and some changes (grrr..) on the local machines re user rights.

I’ll check the link out.