DELETED tables cause error on table Connect? 
Author Message
 DELETED tables cause error on table Connect?

Hi, i have an Access 2000 fe/be database.
Anyway, i just switched my code over for reconnecting to the back-end

It now Deletes the existing link, then re-connects and ignores errors for
insufficient rights.

Anyway, it usually works, but sometimes i get an error because it can't find
some DELETED tables that are still{*filter*} around in the hidden table

Is there a way to purge these orphans and is it normal to have deleted
tables kept in this system table?


Edward Grainger

Thu, 24 Apr 2003 12:40:20 GMT  
 DELETED tables cause error on table Connect?
Answered in

Perth, Western Australia
Tips for MS Access users at:

Thu, 24 Apr 2003 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. Recordset.Delete problem with connected tables

2. using table field names after table connect

3. deleting tables and updating table name

4. Retaining styles in table cells when deleting table


6. Cannot add record to Visual Foxpro table after deleting all records in table

7. create table and delete table with ADO

8. DROP TABLE causes lock error

9. Saving VARIANT variables into table causes error

10. Database with connected tables (dbf) error!

11. Deleting a table and siwtching off errors.

12. ODBC error when using SQL delete from dBase table


Powered by phpBB® Forum Software