Appeal for System Tables (1 Viewer)

isladogs

MVP / VIP
Local time
Today, 10:07
Joined
Jan 14, 2017
Messages
18,186
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
 

Attachments

  • SysTablesSummary v5.5.xlsx
    34.4 KB · Views: 157
Last edited:

isladogs

MVP / VIP
Local time
Today, 10:07
Joined
Jan 14, 2017
Messages
18,186
No responses after a fortnight so just giving this a bump to try again.
Any help appreciated. TIA
 

deletedT

Guest
Local time
Today, 10:07
Joined
Feb 2, 2019
Messages
1,218
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?


Do you have a database containing any of the above system tables?.

Microsoft Access 2019
None of my databases contains these tables.
I checked for stand alone database files and FE with SQL server BE databases.
 

isladogs

MVP / VIP
Local time
Today, 10:07
Joined
Jan 14, 2017
Messages
18,186
Hi Tera
Thanks for checking.

Tables 2 & 4 only appear in certain situations when Access crashes.
Normally users will fix the error and delete the table.
I've seen both in the distant past but have been unable to 'create on demand'.

In the interests of research, I've even tried terminating Access from Task Manager whilst in the middle of a compact routine, during a decompile and whilst writing to a split database with a wireless connection. In other words doing all the sorts of things that are strongly advised against normally! No luck so far :banghead:

The only reference I've ever seen to MSysFilters is in the list of error codes.

I now know MSysConf is a table that can be created in SQL Server for logging issues with SQL BE files connected to Access FEs. See https://sourcedaddy.com/ms-access/sql-server-profiler.html
 

Frothingslosh

Premier Pale Stale Ale
Local time
Today, 06:07
Joined
Oct 17, 2012
Messages
3,276
Sorry, Colin, I'd have replied if I had examples of any of them laying around. I HAVE seen both MSysCompactError and MSysRecoveryErrors before, but they were at previous employers so I can't get my hands on the files. The other three are new to me.
 

isladogs

MVP / VIP
Local time
Today, 10:07
Joined
Jan 14, 2017
Messages
18,186
Thanks anyway.
Those are also the only two in that list I've ever seen.
However, I'm going to try creating my own MSysConf table in SSMS and investigate how useful it seems to be.
A Google search found no references to MSysFilters yet it has its own Access error code
 

isladogs

MVP / VIP
Local time
Today, 10:07
Joined
Jan 14, 2017
Messages
18,186
Just a quick update.
I've now dealt with three of the tables in my earlier list.
I finally managed to create an MSysCompactError table by deliberately doing something stupid.
Doing so created an 'interesting' security breach.... :rolleyes:

All I'm still looking for are:
MSysFilters (97-2003)
MSysRecoveryErrors

Any help with either of those is appreciated
 

Users who are viewing this thread

Top Bottom