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