Kaup, Chester
Chester_Kaup at kindermorgan.com
Tue Jun 7 08:54:37 CDT 2005
I have used this code in many Access 2003 databases successfully. Just tried it in a 2003 version database and it will not open the table. I have checked and the table exists and name matched. I can open the table no problem from the table list. What may be happening here? Sub TableNames() Set MyDB = CurrentDb() Set AllTableDefs = MyDB.TableDefs Set myds = MyDB.OpenRecordset("tbl Table Definitions", dbOpenTable) Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799