1
Databases / Re: MDB: list all tables
« Last post by SymbolicFrank on Today at 09:23:25 pm »2 ways:The one and only thing I (try to) do with them is move the data (tables) to a real SQL database, for the real processing to take place. But the MDB is what I get delivered, so I have to take what I get.
1) GetTableNames returns a TStrings (TStringList). Run through it and remove everything else (hope the naming-schema is clear enough to differentiate)
2) Implement your own "INFORMATION_SCHEMA" --> create your own Table, where you enter only the Tablenames you're interested in
Since i'm avoiding Access like the devil avoids holy water, i can't give you more info
It does work well in Linux (although it tends to bug out every once a while, on Windows as well), but you get no error messages whatsoever, so development has to happen in Windows.