Linking MS SQL 7 or MS Access 97

Linking MS SQL 7 or MS Access 97

Post by josow.. » Wed, 15 Sep 1999 04:00:00



I have to send data back and forth between SQL 7 and a Btrieve
database.  I can query Btrieve and Insert fine, but when updating or
deleting, it seems to only ever affect the last row in the specified
table.  I've tried pursueing this with Btrieve support, but I haven't
had any luck with them yet, nor do I want to spend another two hours
explaining to them that I know how to write SQL commands correctly,
this is a easily replicated bug in their software.

I thought I might try creating a Bridge in MS Access 97, but from what
I've read I need Access 2.0 to link to Btrieve?

I've been on and off this problem for close to two months, and my head
is about to explode.

Can anyone out there please provide some insight?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

 
 
 

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. Email Records from View

3. Removing DTS Metadata from the Repository

4. MS Access 97 SQL to MS SQL SQL SQL SQL

5. ODBC-driver for MS query / Paradox

6. How to migrate from MS Access 97 to MS SQL server 6.5

7. CA-ORACLE DATA WAREHOUSE ETL SPECIALIST

8. Upsizing MS Access 97 to MS SQL Server

9. Calling MS ACCESS 97 Cross-Tab Query from MS SQL 6.5

10. Connecting to MS SQL Server 6.5 via MS Access 97 and ODBC

11. Link Table to SQL Server 2000 from MS Access 97

12. MS Access 95/97, MS ODBC 3.0, Sybase 11 problem