isladogs
MVP / VIP
- Local time
- Today, 01:46
- Joined
- Jan 14, 2017
- Messages
- 18,221
As some of you may know, I have been publishing a series of reference articles about Access system tables over the past few months.
Some examples include:
Purpose of System Tables
How Access Stores Queries
Using multivalued fields..and why you really shouldn't
How Access manages Relationships
Using Column History in Memo/Long Text fields
Remove deleted objects from MSysObjects
I have now documented 64 different system tables and have summarised the properties of almost all of these - see attached Excel file
However for various reasons, I haven't been able to generate several of the tables recently myself.
In one sense that's a good thing as some of those are related to crashes or application errors.
MSysConflicts (97-2003) - details of replication conflicts
MSysCompactError (all versions?) - lists errors during compact & repair
MSysFilters (97-2003) -not sure what it does
MSysRecoveryErrors (all versions?) - created during a crash recovery
MSysConf - new to me - possibly same as MSysConflicts?
For info, several of these are mentioned in the list of Access errors
3505 : You attempted to delete or get information about a partial filter that does not exist in MSysFilters.
3407: The server's MSysConf table exists, but is in an incorrect format. Contact your system administrator.
32506/32507: Microsoft Access has recovered this database, but one or more tables were found to contain data corruption and were deleted. Deleted tables were logged in the MSysRecoveryErrors table.
In order to ensure the articles are as complete/accurate as I can make them, this is an appeal to all forum members.
Do you have a database containing any of the above system tables?.
If you do, please could you copy them into a separate database, zip & email them to me using the link in my signature line.
I don't need the rest of the database, just any of the system tables concerned
Also if anyone is aware of other system tables not included in the attached Excel file, please can you pass on any relevant information
NOTE: All the system tables articles include a warning paragraph similar to this
--------------------------------------------------------------------------
IMPORTANT
System tables are used by Access to make databases function correctly
Some system tables can be viewed & a few can be edited
But that doesn't mean you should do so ....UNLESS YOU ARE ABSOLUTELY SURE WHAT YOU ARE DOING
Altering one table may have 'knock on' effects on other tables
Incorrectly editing system tables may corrupt your database or prevent you opening it
--------------------------------------------------------------------------
Thanks in advance
FYI: I have posted the same appeal at: https://www.utteraccess.com/forum/index.php?showtopic=2052531&st=0#entry2710192
Some examples include:
Purpose of System Tables
How Access Stores Queries
Using multivalued fields..and why you really shouldn't
How Access manages Relationships
Using Column History in Memo/Long Text fields
Remove deleted objects from MSysObjects
I have now documented 64 different system tables and have summarised the properties of almost all of these - see attached Excel file
However for various reasons, I haven't been able to generate several of the tables recently myself.
In one sense that's a good thing as some of those are related to crashes or application errors.
MSysConflicts (97-2003) - details of replication conflicts
MSysCompactError (all versions?) - lists errors during compact & repair
MSysFilters (97-2003) -not sure what it does
MSysRecoveryErrors (all versions?) - created during a crash recovery
MSysConf - new to me - possibly same as MSysConflicts?
For info, several of these are mentioned in the list of Access errors
3505 : You attempted to delete or get information about a partial filter that does not exist in MSysFilters.
3407: The server's MSysConf table exists, but is in an incorrect format. Contact your system administrator.
32506/32507: Microsoft Access has recovered this database, but one or more tables were found to contain data corruption and were deleted. Deleted tables were logged in the MSysRecoveryErrors table.
In order to ensure the articles are as complete/accurate as I can make them, this is an appeal to all forum members.
Do you have a database containing any of the above system tables?.
If you do, please could you copy them into a separate database, zip & email them to me using the link in my signature line.
I don't need the rest of the database, just any of the system tables concerned
Also if anyone is aware of other system tables not included in the attached Excel file, please can you pass on any relevant information
NOTE: All the system tables articles include a warning paragraph similar to this
--------------------------------------------------------------------------
IMPORTANT
System tables are used by Access to make databases function correctly
Some system tables can be viewed & a few can be edited
But that doesn't mean you should do so ....UNLESS YOU ARE ABSOLUTELY SURE WHAT YOU ARE DOING
Altering one table may have 'knock on' effects on other tables
Incorrectly editing system tables may corrupt your database or prevent you opening it
--------------------------------------------------------------------------
Thanks in advance
FYI: I have posted the same appeal at: https://www.utteraccess.com/forum/index.php?showtopic=2052531&st=0#entry2710192
Attachments
Last edited: