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

access courses - multi user database

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

access courses - Multi user database

ResolvedVersion 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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.