looking for a table in the tabledefs collection

[ziwacky]

Will someone know the why of this one.

I am importing a table using docmd.transferdatabase. If I loop through all the tabledef in my tabledefs collection, sometimes I can see the new table included in the list, and sometimes I don't. Mostly I don't and I need to see for what I'm trying to do.

Thx, Z

 

[rbowes]

After importing, try "RefreshDatabaseWindow" then loop through.

I didn't try it out, but it should work.

 

[rewdee]

Hi Z

After importing are you calling db.tableDefs.Refresh where db is a variable of a database type.

Hope this helps,
Rewdee