MS Access 2 & 97 and Btrieve 7.0

MS Access 2 & 97 and Btrieve 7.0

Post by Sandy Nowa » Mon, 12 Oct 1998 04:00:00



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?

 
 
 

MS Access 2 & 97 and Btrieve 7.0

Post by Douglas Reill » Mon, 12 Oct 1998 04:00:00


Sandy,

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?


 
 
 

1. MS-Access 97 to SQL Server to MS-Access 97

Hi this is a thread from another news group that has not been
answered. Any ideas anyone?

Thank You, Thank You...you hit it right on the money. It seems SQL
import/export converted all my MS-Access memo fields to the SQL ntext
data type. Does SQL Server have a comparable memo field type? If not
how do people get around the memo field requirement? Create text field
large enough for the average requirement?

Thanks Again

On Thu, 17 Jun 1999 16:40:30 +0400, Alexey Dolganov

2. Acessing MS SQLSERVER

3. sql 7 - fulltext err: 80004005

4. Btrieve DB access from MS Access 97 application

5. ?This SQL statement won't work -- Microsoft.Jet.OLEDB.4.0 has reserved words?

6. MAX Btrieve availability to MS Access 2, and 97

7. Q: How2 encrypt mdb files accessed by VB apps

8. Importing Btrieve 7 data on local HD to MS Access 97

9. Btrieve 5.10a & Access 97

10. Migration from MS Access 97 to SQL Server 7.0

11. SQL Server 7.0 database with MS Access 97 Frontend