You can kind of use the old ISAM driver (the Access driver is called
BTRV200.DLL or similar) with Access 97 but only if you have the old version
of access on the machine, attach the tables from Access 2 and then attach to
that A2 MDB from Access 97. Not really pretty.
No Btrieve ODBC driver I am aware of allow spaces in names. The spaces are
converted to '^' characters. In access, you can then do an alias query to
get at the data with the field names with the spaces, since Access likes
spaces in field names (if you surround them with [ ]). I will be doing an
article on getting at Btrieve data from Access for the Winter issue of the
Pervasive Software Developer's Journal.
>In Access 2, I could use Novell ISAM drivers (WBTRCALL.DLL ect) to attach
>Btrieve tables which allowed spaces in field and file names in the DDFs.
>1. Can the Novell ISAM drivers be used with Access 97?
>2. If they can - how? Set up a DSN?
>3. If I'm forced to use ODBC do any of these allow spaces in field and file
>names? Which ones?