Connect to Access 97

Connect to Access 97

Post by Tony Brow » Wed, 24 Mar 1999 04:00:00

Does microsoft only interface to databases through MFC?  All I am
looking for is a simple exe program.  Something were you do a line
command execution like:

programName arg1 arg2

and the program will cout the record that it matches arg1 and arg2.
This is my first experience with databases so, I am looking for
simplicity over flexibility.  The examples in the help files are a
little more complex than I am looking for, I like to take very small
stages while I am learning something.  Any suggestions would be great.

Tony Brown


1. ODBC timeout when connecting from ACCESS 97 to SQL Server 6.5 (heavy loaded server)


our ACCESS 97 application connects to SQL Server. When retrieving a
large number of records we sometimes get an ODBC timeout.
(maybe due to a heavy loaded SQL Server)
This sometimes makes it impossible to execute the query for quite a
long time (in some cases for several hours !!)

Where can I change the number of milliseconds when ACCESS timeouts the
query ?

May changing the query to ODBC direct or SQL pass through be a
solution ?

Please answer also by email.

Many thanks in advance for your help,

Cheers, Bernd.

2. Merge Replication problem

3. Can't connect to Access 97 DB

4. String max length

5. Connecting to Access 97 using ODBC -How?

6. Migrating Data From OODB

7. Connecting to Access 97 Database using ADO with OLE DB Driver

8. extender characters & delphi 3

9. Problem connecting to Access 97 .mdb

10. Connecting to Access 97 Database using ADO with OLE DB Driver

11. Connecting to Access 97

12. How to connect to Access 97 database?

13. using JDBC to connect to Access 97 database