| GeoWhe 2005-08-30, 9:55 pm |
| Mike, I did not think that 'Set rsCompany = DB.Recordsets("Select * FROM
Company")' was creating the table. But the 'DB.Execute "ALTER TABLE " &
txtDept(x).text & (FullName text (35), NameCode text (8)...)' does create an
Access table in the current Access database. My issue/question is that I do
not know how to remove or delete the newly created or another table in the
same database.
I appreciate your help. George
"MikeD" wrote:
>
> "GeoWhe" <GeoWhe@discussions.microsoft.com> wrote in message
> news:5BEB2E65-C3F8-45A5-8BFD-097434D5E8DF@microsoft.com...
>
> That's not creating a table. It's just returning rows from an EXISTING table
> into a recordset.
>
>
> Given that you thought you were *creating* a *table* with your SELECT
> statement, I'm not sure if what you're really asking is how to delete a
> table or how to delete records from a table.
>
> Can you clarify/elaborate?
>
> --
> Mike
> Microsoft MVP Visual Basic
>
>
>
|