Closing ODBC Access 2.0 database 
Author Message
 Closing ODBC Access 2.0 database

I am doing work on a VB application that uses an ODBC driver to connect
to an Access 2.0 Database.  I just noticed that the database doesn't
really close when you execute the close method -- eg.  mydb.Close.  This
causes a problem because I need to read from the database and then later
in the program open Access and compress the database using DDE.  Access
gives the error that the database can't be opened exclusively because it
is already opened by me.  This is really frustrating because I specifically
closed it.
        I monitored the temp files that are created when the database is
opened and I noticed that they did not go away when I issued the close method.
They only go away when I exit the VB program.  I tried deleting the temp
files myself but I am blocked by share.

        If anyone could help I'd be grateful.

Mon, 09 Feb 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Accessing Access 2.0 database with VB3, ODBC 2.0 and Microsotf Jet Engine Compatibility Layer

2. Problems accessing ACCESS 2.0 databases from ODBC

3. Compacting an Access Database using ODBC 2.0

4. Closing Access ODBC Database

5. Problems accessing Access 2.0 via ODBC 2.x from VB3.0

6. Convert access 2.0 to access 2000 database

7. Convert Access 2.0 database into Access 97

8. Visual basic 3.0 accessing Access 2.0 databases

9. Help : Accessing a secure access 2.0 database from VB4.0

10. How to access Access 2.0 databases?

11. How to access Access 2.0 databases?

12. Accessing Access 2.0 databases with Jet 3.5


Powered by phpBB® Forum Software