delete a table in an external database

Tony

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?

Thx in advance
Tony

Nov 12 '05 #1

Bas Cost Budde

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

Nov 12 '05 #2

Pavel Romashkin

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

Nov 12 '05 #3

Bas Cost Budde

Pavel Romashkin wrote:

I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename

Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #4

Pavel Romashkin

It does. Give it a shot.
In fact, if you use QBE to create a table in external DB, this is kind
of SQL you see in the SQL view.

Pavel

Bas Cost Budde wrote:

Pavel Romashkin wrote:

I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename

Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #5

Tony

Thx a lot guys

"Pavel Romashkin" <pa*************@hotmail.com> skrev i en meddelelse
news:40***************@hotmail.com...

It does. Give it a shot.
In fact, if you use QBE to create a table in external DB, this is kind
of SQL you see in the SQL view.

Pavel

Bas Cost Budde wrote:

Pavel Romashkin wrote:

I would probably simply use

DROP TABLE [External_DB_Path_and_Filename].Tablename

Interesting! Does CREATE TABLE do that, too?

--
Bas Cost Budde
http://www.heuveltop.org/BasCB
but the domain is nl

Nov 12 '05 #6