I would probably simply use
DROP TABLE [External_DB_Path_and_Filename].Tablename
in an action query or code. No need for opening connections explicitly.
Pavel
Bas Cost Budde wrote:
Tony wrote:
hi NG
I have got a database, and from this database I want to delete a table in
another database, before Iexport a new table to that other database.
My question is how can I delete a table in a forein database?
air code:
dim db as database
set db=opendatabase(yourwhatever)
db.execute "drop table yourtable"
db.close
set db=nothing
--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl