access courses - multi user database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » access courses - Multi user database

access courses - Multi user database

resolvedResolved · Low Priority · Version Standard

Ricardo has attended:
Access VBA course
Access Advanced course

Multi user database

Can multiple IIF statements in a form significantly slow the form down?

Thanks

Ricardo

RE: Multi user database

The simple answer is No.

Regards

Carlos

RE: Multi user database

Thanks Carlos. I ask as I have a database split into fe/be and I found that the forms on the front end with the IIF statements were very slow, but when they were taken out the form was much faster, also during the pause the form says "calculating..." in the status bar.

Would IIF statements on a form cause a slowdown effect in such a case where they look up information in a back end database of roughly 5Mb)?

Thanks again


Ricardo

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


Server loaded in 0.09 secs.