Delete a Table not in Current Database

How can I delete a table in a database that is open but is not the current
database?

Thank you

Ross

This might be a help for getting data to and from Excel and Access: It
includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table
* insert records
* select records,
* update records,
* delete records,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Ross" <Ross@discussions.microsoft.com> wrote in message
news:34DCBD39-3886-457B-B0A3-3C9F54AAA465@microsoft.com...
> How can I delete a table in a database that is open but is not the current
> database?
>
> Thank you
>
> Ross

Andy,

I think this posted to the wrong question. Perhaps it should be the next
question down?
Ross

"Ross" wrote:

> How can I delete a table in a database that is open but is not the current
> database?
>
> Thank you
>
> Ross

???

Did you wanted to know how to delete a table from a database? My post tells
you how.

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"Ross" <Ross@discussions.microsoft.com> wrote in message
news:EACF0CC9-BBFA-40F9-86BC-6419C3AD4F52@microsoft.com...
> Andy,
>
> I think this posted to the wrong question. Perhaps it should be the next
> question down?
> Ross
>
> "Ross" wrote:
>
> > How can I delete a table in a database that is open but is not the
current
> > database?
> >
> > Thank you
> >
> > Ross