Full Version: Drop linked table
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
CHKarcher
What is the code to drop a linked table?

Tia
steve
CHKarcher
Got it -


Dim dbs As Database
Set dbs = CurrentDb

dbs.Execute "DROP TABLE tempLease"

steve
niesz
Or simply:

CurrentDB.Execute "DROP TABLE tempLease", dbFailOnError
CHKarcher
I like yours better - thanks
niesz
NP.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.