Data editing control

[rprobinson]

I have a multi user system that has a set of back-end data table files and a few front end modules that contain user logic (forms, reports, etc.)

I want to set several parameters on the 'Advanced' tab of the 'Options' dialogue box to control timeouts, refresh intervals, # of update retries, refresh interval and retry interval.

My question is: Where should these values be set? In the .MDB file that contains the tables, or in the .MDB file that contains the actions being taken on the tables? Do both have to be set to same values? Which takes precedence?

I would appreciate any help that anyone can provide?

Thanks.

 

[KernelK]

You would set these all in the Front End of your application as this is where the actions that use these values are located. I assume these intervals, and retry variables are all used by your programming logic in the Front End to perform actions, and if so it is easiest to look for these values in the same database that contains the code.

If you set them in the backend, your Front End would have to check the values in the Back End each time it needs to reference them. This would create a new connection (depending on how you retrieve information from the Back End) each time, or at least force the application to look at an external resource and would slow down the overal application performance.