Info about Extra-Options-->Tab Advanced

[Lars Brownie]

I'm looking for some developer-experience documentation about the tab
Advanced from the Extra-Options menu. Is this available somewhere?
Thanks, Lars

 

[Arvin Meyer [MVP]]

I'm looking for some developer-experience documentation about the tab
Advanced from the Extra-Options menu. Is this available somewhere?
Thanks, Lars

I think that you mean Tools >>> Options >>> Advanced tab?

The help files contain information on the individual items. For instance, if
you search Help for "RecordLocks" you'll get an explanation of what and how
to choose record locking.

 

[Lars Brownie]

Thanks Arvin, yes that's what I meant. I was kinda hoping for a best
practice document with do's and dont's since the Help file doesn't always
meet with daily practice. What I'm specifically unsure of are the settings
on the left side of the tab, like the DDE commands and refresh settings and
all the numeric refresh values below that.

Lars

 

[Arvin Meyer [MVP]]

The reason that they are options is that they need to be able to change,
depending upon the conditions. I would expect that the defaults are typical
best practice values. I, usually leave the RecordLocks at NoLocks unless I
have any locking problems. The other values have been used as the default
since I've been using Access, without problems, unless I choose another
database engine as a backend. In that case, I'd change the ODBC timeout to
that recommended by the engine I'm using.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com