February 2013
Intermediate to advanced
304 pages
8h 26m
English
Scenario/Problem: You need to modify the maximum amount of records allowed in an Access table.
Solution: Use the RecordsInTableMax parameter with the Set-SPAccessService Application cmdlet.
The RecordsInTableMax parameter has a default value of 500000 and determines the maximum number of records that can be contained within an Access table used within Access Services. An entry of -1 means unlimited, whereas the valid range of values for this parameter is 1 to the maximum integer value allowed. Listing 23.7 shows a sample modification of the maximum number of records.
Listing 23.7. Changing the Maximum Number of Records in a Table
Set-SPAccessServiceApplication -Identity "Access Services" ...
Read now
Unlock full access