Skip to content

TypeError: 'NoneType' object is not subscriptable with MDB file from AADvance Workbench #37

@alexchandel

Description

@alexchandel

Hello, I encounter this error when trying to parse a certain table (the Symbols table) of an MDB file produced by AADvance Workbench. Can you help with this?

> uv run main.py
Error while parsing MSysObjects table chunk.
Error while parsing MSysObjects table chunk.
Error while parsing MSysObjects table chunk.
... (above message repeated a lot) ...
Failed to parse memo field. Using data as bytes
Failed to parse memo field. Using data as bytes
Failed to parse memo field. Using data as bytes
Failed to parse memo field. Using data as bytes
Failed to parse memo field. Using data as bytes
Could not find overflow record data page overflow pointer: 32774
Traceback (most recent call last):
  File "C:\src\testpy\main.py", line 15, in <module>
    main()
    ~~~~^^
  File "C:\src\testpy\main.py", line 11, in main
    print(tabulate(db.parse_table('Symbols'), headers='keys'))
                   ~~~~~~~~~~~~~~^^^^^^^^^^^
  File "C:\src\testpy\.venv\Lib\site-packages\access_parser\access_parser.py", line 186, in parse_table
    return self.get_table(table_name).parse()
           ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^
  File "C:\src\testpy\.venv\Lib\site-packages\access_parser\access_parser.py", line 258, in parse
    self._parse_row(record)
    ~~~~~~~~~~~~~~~^^^^^^^^
  File "C:\src\testpy\.venv\Lib\site-packages\access_parser\access_parser.py", line 302, in _parse_row
    self._parse_dynamic_length_data(original_record, metadata, relative_records_column_map, null_table)
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "C:\src\testpy\.venv\Lib\site-packages\access_parser\access_parser.py", line 428, in _parse_dynamic_length_data
    parsed_type = self._parse_memo(relative_obj_data)
  File "C:\src\testpy\.venv\Lib\site-packages\access_parser\access_parser.py", line 555, in _parse_memo
    next_page = struct.unpack("I", rec_data[:4])[0]
                                   ~~~~~~~~^^^^
TypeError: 'NoneType' object is not subscriptable

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions