Access-based interpretation databases are no longer supported in Geocene3D and have been replaced by the SpatiaLite format. To continue working with existing data, a one-time conversion to SpatiaLite is required.

During the conversion, a new SpatiaLite .sqlite file is created, and all valid interpretation data is copied into it. Once the conversion is complete, the new database is ready for use — you can start edit sessions and add new interpretation points as needed.

1. Open the Source Manager

• Click the Source Manager icon in the toolbar or use the Manager menu.

2. Find the Access database

• In the source list, locate the row with Type: Access and identify the correct file.

3. Right-click and convert

• Right-click the Access source and select Convert To SpatiaLite… from the context menu.

4. Configure conversion settings

• In the SpatiaLite Conversion dialog:
• Click Points EPSG… and choose the appropriate EPSG code
• Set the Destination File Name for the new .sqlite file
• Click Convert and Replace

5. Check result in Source Manager

• A new SpatiaLite source is added to the list
• The original Access source remains but is no longer used
• Any linked point layers (e.g., L1, L2) are now automatically connected to the new SpatiaLite file

• Optional: Select “Used by” to see which interpretations point are now using the new Spatialite file

6. Start editing

• The project is now ready to continue with the converted database
• You can start a new edit session or use Setup Data for Modeling to add points to the new database

• Only tables with UID, X, Y, and Z columns are included in the conversion
• These columns are required for a table to be recognized as an interpretation table
• For each valid table, all fields are preserved in the SpatiaLite output
• Tables are included even if they were not imported as point layers in the Layer Manager
• This ensures a complete and independent conversion of all valid interpretation tables

• During conversion, the X and Y columns from Access are merged into a single geometry field named XYPoint
• This field is stored as a 2D POINT with the selected EPSG code, used for correct placement in external GIS tools (e.g., QGIS)
• The Z value is kept as a separate column representing elevation
• Geocene3D itself does not use projections, so the EPSG code is only relevant when working with external applications

• Access sources can be converted immediately after being added, even if no tables are imported or linked to layers
• In this case, the source appears as Database in the Source Manager
• This enables a fast, stand-alone upgrade to SpatiaLite without any project setup
• After conversion, the new .sqlite file can be used in Setup Data for Modeling to add interpretation points