In our example, the query would be named IceCreams and would execute the SQL select * from. It will also create a new query with the original table name, that will select all columns of the renamed table. the table IceCreams would be renamed to IceCreams_Table. As a precaution, backup your database first.Ĭall AddWorkaroundForCorruptedQueryIssue() to apply the workaround and RemoveWorkaroundForCorruptedQueryIssue() to remove it at any time.ĪddWorkaroundForCorruptedQueryIssue() will add the suffix _Table to all non-system tables, e.g. Use the basWorkaround.bas module to automatically implement Microsofts suggested workaround (using a query instead of a table). Make sure that either the Microsoft DAO 3.6 Object Library (backward compatibility) or Microsoft Office x.x Access Database Engine Object Library reference is enabled under VBA Editor -> Tools -> References (see #1 for further details). This workaround should therefore be obsolete after the fix got applied and anybody who has used it can call the RemoveWorkaroundForCorruptedQueryIssue() function to restore the original application state. Microsoft did release a fix for this issue on (patch day) that will by default be automatically installed via WSUS etc. In contrast to those, the intention of the one provided here is to work by automatically altering the MDB/ACCDB content itself with as little work as possible. There are other workarounds out there that need to be applied on an administrative level, e.g. The latest workaround for the Query is corrupt error introduced with CVE-2019-1402 in MS Access. CorruptQueryAccessWorkaround: Query '' is corrupt
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |