[AccessD] Code to open table fails

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

 




More information about the AccessD mailing list