AccessBlog.net

News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Alex
Name:Alex Dybenko

Location:Moscow, Russia

Monday, September 17, 2012

MSysConf table

This system table is not very known, but it offers 2 unique possibilities:

  • It can disable the feature that enables users to save the logon ID and password for a linked SQL database in the Microsoft Access front end.
  • It can optimize how Microsoft Access performs background population of records during idle time by setting the number of rows of data that are retrieved at one time and the number of seconds of delay between each retrieval. Microsoft Access uses a default of 100 records that are returned every 10 seconds if you don't create the MSysConf table.

Do not try to find it in you mdb, unlike other system tables you have to create it by yourself, in SQL server database. All details on table structure and configuration options you can find at About using the MSysConf table to optimize your linked SQL database (MDB) and at How to store SQL database login IDs and passwords locally.

Labels: ,

1 Comments:

Blogger Tom Wickerath said...

Hi Alex!
Looks like someone at Microsoft decided it was time to break another URL :-(

Do you have an updated URL available for the first article you linked to?

About using the MSysConf table to optimize your linked SQL database (MDB)

Tom

11:27 PM  

Post a Comment

<< Home