VBA, delete external DB's table from current DB?

delete external DB's table from current DB?

Author	Message
Jesse Scot #1 / 5	delete external DB's table from current DB? I'd like to make it so that a macro I run deletes a table in an external database before doing several other operations. Is this a possibility with macros? If not, is there relatively easy code that will work it out? Thanks in advance.
Mon, 17 Sep 2001 03:00:00 GMT

Richard Sbragi #2 / 5	delete external DB's table from current DB? In its purest form Sub DelTbl() Dim db As Database Set db = OpenDatabase("<Name of DB with PATH>") db.TableDefs.Delete ("<Name of table in db>") End Sub This does not address errors for invalid path, file not found, table not found, etc... Maybe resume next error handler... HTH Rich Quote: >I'd like to make it so that a macro I run deletes a table in an external >database before doing several other operations. >Is this a possibility with macros? If not, is there relatively easy code >that will work it out? >Thanks in advance.
Mon, 17 Sep 2001 03:00:00 GMT

Jesse Scot #3 / 5	delete external DB's table from current DB? Quote: > Sub DelTbl() > Dim db As Database > Set db = OpenDatabase("<Name of DB with PATH>") > db.TableDefs.Delete ("<Name of table in db>") > End Sub Will this keep the db that the user is currently in open? I mean, in all my past experience, opening an external db from within one always closes the current one in order to open the external one. When I run this procedure as a first step in a larger sub, will the db the the code's in stay open? Thanks.
Sat, 22 Sep 2001 03:00:00 GMT

Michel Wals #4 / 5	delete external DB's table from current DB? Hi, The GUI will stay the same, basically db will be just a reference (an alias) to a (another) database. Vanderghast, Access MVP. Quote: > > Sub DelTbl() > > Dim db As Database > > Set db = OpenDatabase("<Name of DB with PATH>") > > db.TableDefs.Delete ("<Name of table in db>") > > End Sub > Will this keep the db that the user is currently in open? I mean, in all > my past experience, opening an external db from within one always closes > the current one in order to open the external one. When I run this > procedure as a first step in a larger sub, will the db the the code's in > stay open? > Thanks.
Sat, 22 Sep 2001 03:00:00 GMT

Paul Bredbu #5 / 5	delete external DB's table from current DB? says... Quote: > > Sub DelTbl() > > Dim db As Database > > Set db = OpenDatabase("<Name of DB with PATH>") > > db.TableDefs.Delete ("<Name of table in db>") > > End Sub > Will this keep the db that the user is currently in open? I mean, in all > my past experience, opening an external db from within one always closes > the current one in order to open the external one. When I run this > procedure as a first step in a larger sub, will the db the the code's in > stay open? Yes, because the database is only being opened into an object variable, rather than the user interface. -- Paul Bredbury, http://dialspace.dial.pipex.com/brebs/
Sat, 22 Sep 2001 03:00:00 GMT

Page 1 of 1

[ 5 post ]