VCS 4.0.34: Unhandled error when exporting missing linked table

[HughWarrington]

-------------------------------------
my_database.mdb
VCS Version 4.0.34
Performing Full Export
22/03/2024 13:30:09
-------------------------------------

Running with debug enabled.

I think the screenshots help explain what's going on.

It's trying to export data from a table. clsDbTableData.GetTableExportSql has generated a select query that is missing the ORDER BY columns at the end. I'm guessing this is because the table in question is a linked table that cannot be found on disk.

I'm not sure what the conventions are in this project (or in Access/VB in general) but perhaps we should instead log a meaningful warning saying 'missing linked table' or similar.

[joyfullservice]

Yes, it looks like we should test to ensure the table exists and is available before attempting an export of the data. Good idea!

[joyfullservice]

Added some code to ensure the availability of the target for linked tables, and logs the error more clearly for the user.

[HughWarrington]

Brilliant! Thank you.

[hecon5]

If this is working @HughWarrington, can you close it? Thank you!