A. You need to at least be on BDE 5.01. This knows about SQL 7.0 systems tables etc. However it is still db-lib based and therefore does not support Unicode, Varchars greater than 255 bytes and any other SQL 7.0 only feature.
Inprise (Borland) will be bringing out an ADO alternative in the future - check their website for details.
Download of current BDE: http://www.borland.com/devsupport/bde/
BDE info: http://www.borland.com/bde/
BDE Q&A: http://www.borland.com/devsupport/bde/qanda/
Delphi info: http://www.borland.com/delphi/
SQLLinks info: http://www.borland.com/sqllinks/
For a non-Inprise solutions check out http://www.kylecordes.com/bag/index.html