If TableA exists then . . .

[ezrider]

Hi again

How can I do an existence test on a table in my Access MDB in a script. The job is to determine if a temp table exists, and if so, then to drop the table.

What syntax would I use to accomplish this in form event code?

Thanks

EzRider

 

[freakazeud]

Drop Table if exists!

Hi,
look through this: http://www.mvps.org/access/tables/tbl0001.htm
Then use that code and drop your table. Something like:

If fExistTable = True Then
CurrentDb.Execute "DROP fExistTable"
End If

HTH
Good luck

 

[esskaykay]

I too am looking to a way to test for existing of a table. However, I want to test the location of a table in a remote network database. Where in the code found in http://www.mvps.org/access/tables/tbl0001.htm do I place the path, database name, and table name?

Thanks,
SKK

 

[nateobot]

I too am looking to a way to test for existing of a table. However, I want to test the location of a table in a remote network database. Where in the code found in http://www.mvps.org/access/tables/tbl0001.htm do I place the path, database name, and table name?

Thanks,
SKK

You would have to modify the function to accept those parameters. It is written to test for the current database only.