L
Larry Stinson
I have found using the ADO catalog and its tables collection the fastest way
to "re-link" tables in an Access 2000 database (actually, I delete the old
table and create a new one with the different link). But I ran into a
puzzling problem on just certain databases. After the new ADOX catalog is
created and connected to the database, I start to iterate the tables in the
catalog. This causes the program to unexpectedly shutdown (this happens in
both Access 2000 VBA and Visual Basic).
I have tried creating a blank database and then importing the tables, forms,
reports and modules from the database file that caused the error. When I
iterate the ADO tables collection, no problems. But then when I import the
queries, the problem reappears.
I have also tried importing only a certain number of queries, and that works
fine until a certain number of queries are reached. But I have another
Access 2000 program that has many more queries and tables than the offending
one, and I have no problems at all iterating the tables in that database.
Any ideas on how to resolve this problem would be greatly appreciated!!
to "re-link" tables in an Access 2000 database (actually, I delete the old
table and create a new one with the different link). But I ran into a
puzzling problem on just certain databases. After the new ADOX catalog is
created and connected to the database, I start to iterate the tables in the
catalog. This causes the program to unexpectedly shutdown (this happens in
both Access 2000 VBA and Visual Basic).
I have tried creating a blank database and then importing the tables, forms,
reports and modules from the database file that caused the error. When I
iterate the ADO tables collection, no problems. But then when I import the
queries, the problem reappears.
I have also tried importing only a certain number of queries, and that works
fine until a certain number of queries are reached. But I have another
Access 2000 program that has many more queries and tables than the offending
one, and I have no problems at all iterating the tables in that database.
Any ideas on how to resolve this problem would be greatly appreciated!!