[AccessD] Has anyone here ever tinkered with MSysConf?

Ryan W wrwehler at gmail.com
Thu Mar 23 10:39:08 CDT 2017


I just thought it would be interesting to experiment with option 103 for
background chunk fetch. AFAIK the default is 100 rows at a time.

On Thu, Mar 23, 2017 at 10:30 AM, Jim Dettman <jimdettman at verizon.net>
wrote:

>
> <<Unfortunately I can't find an official MS Article relating to the
> MSysConf
> table for Access.>>
>
>  and you won't.
>
>  Microsoft has never documented any of the Msys tables.  Part of the reason
> for that is that everything they contain is settable by the Access UI
> and/or
> code.
>
>  They would also always issue the warning that "format of the Msys tables
> may change from release to release and you should not rely on those values"
>
>  But with that said, certain tables like Msysobjects has changed very
> little
> since Access 2.0 on most of the fundamental stuff.  Others have gone
> through
> over hauls or been added/removed entirely.
>
> Jim.
>
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Ryan W
> Sent: Thursday, March 23, 2017 11:09 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Has anyone here ever tinkered with MSysConf?
>
> Unfortunately I can't find an official MS Article relating to the MSysConf
> table for Access.
>
> The first half of this Oracle document describes it well enough:
>
> https://docs.oracle.com/cd/A83908_02/NT816EE/DOC/nt.816/z26073/ch5.htm
>
>
> It's also mentioned in Access 2010 VBA Inside and Out:
>
> https://books.google.com/books?id=1T8FCAAAQBAJ&pg=
> PA587&lpg=PA587&dq=access+
> msysconf&source=bl&ots=qv14ZFceO8&sig=StMTuZUUp6dxxF-
> LwvTDPfQJ1_8&hl=en&sa=X
> &ved=0ahUKEwj1rarx8-zSAhUKyGMKHRaDBQU4ChDoAQgsMAM#
> v=onepage&q=access%20msysc
> onf&f=false
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list