UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Drop linked table    
 
   
CHKarcher
post Jun 25 2008, 07:51 AM
Post #1

UtterAccess Veteran
Posts: 450
From: Oklahoma
What is the code to drop a linked table?

Tia
steve
Go to the top of the page
 
+
CHKarcher
post Jun 25 2008, 08:03 AM
Post #2

UtterAccess Veteran
Posts: 450
From: Oklahoma
Got it -


Dim dbs As Database
Set dbs = CurrentDb

dbs.Execute "DROP TABLE tempLease"

steve
Go to the top of the page
 
+
niesz
post Jun 25 2008, 08:04 AM
Post #3

Utter A-fishin'-ado
Posts: 17,723
From: Cincinnati, Ohio, USA . . . ><((((°>
Or simply:

CurrentDB.Execute "DROP TABLE tempLease", dbFailOnError
Go to the top of the page
 
+
CHKarcher
post Jun 25 2008, 08:24 AM
Post #4

UtterAccess Veteran
Posts: 450
From: Oklahoma
I like yours better - thanks
Go to the top of the page
 
+
niesz
post Jun 25 2008, 08:25 AM
Post #5

Utter A-fishin'-ado
Posts: 17,723
From: Cincinnati, Ohio, USA . . . ><((((°>
NP.
Go to the top of the page
 
+
« Next Oldest · Access Queries · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 21st May 2013 - 09:26 AM