# Re: 如何得知 在.MDB档中有某一TABLE存在?

Posted by lijen on December 24, 1998 at 11:33:46:

In Reply to: 如何得知 在.MDB档中有某一TABLE存在? posted by jan on December 24, 1998 at 10:03:42:

: 请问: 应如何得知在 TMP.MDB 资料库中, 是否有 TEST 的TABLE 存在?

try following code:

1. dim mydatabase as database
dim mytable as tabledef
2. set mydatabase = opendatabase("tmp.mdb")
3. for each mytable in mydatabase.tabledefs
if mytable.name = "test" then
.........
endif
next mytable
4. mydatabase.close

Follow Ups: