Very Computer

What is the fastest way to delete an Access table in VB?  currently I am
using the following Action Query:  

    dbAxysData.Execute "DELETE * FROM " & tblAxysData

This works, but it takes more than 12 minutes to complete.  I am
considering the following and would appreciate your input:

1) Delete the entire table (as opposed to deleting the records within the
table) then re-create it.  I know that it is possible to delete a TableDef,
but I am not clear on whether you can delete the table itself and the data
that it contains.  

2) Delete the MDB file then copy a new one in from another sub-directory.  

Stats:

*VB 3.0 Pro
*Access 2.0 database file with Compatibility Layer
MDB size:    26 MB
Records:     265,000
Workstation: Pentium 133, 43 MB RAM
Nertwork:    10Base-T (MDB in on a server)

* This application will be ported to VB 5 Enterprise with an Access 97
database file sometime in the next few months.  

Thanks for any help.  

Louis Wood

Quote:>1) Delete the entire table (as opposed to deleting the records within the
>table) then re-create it.

dbAxysData.Execute "DROP  TABLE " & tblAxysData

    ...Joe Maki
    MT Kupp & Associates

If this process is something you don't have to perform while the user
waits, maybe you could schedule a delete at night while the user goes
home.

If you have any information about this, please provide more so I can
help more.

you can also try the TRUNCATE sql operation.  I'm not sure if access
supports this but the major DBMSs do.  Good luck

Quote:> What is the fastest way to delete an Access table in VB?  currently I am
> using the following Action Query:  

>     dbAxysData.Execute "DELETE * FROM " & tblAxysData

> This works, but it takes more than 12 minutes to complete.  I am
> considering the following and would appreciate your input:

> 1) Delete the entire table (as opposed to deleting the records within the
> table) then re-create it.  I know that it is possible to delete a
TableDef,
> but I am not clear on whether you can delete the table itself and the
data
> that it contains.  

> 2) Delete the MDB file then copy a new one in from another sub-directory.

> Stats:

> *VB 3.0 Pro
> *Access 2.0 database file with Compatibility Layer
> MDB size:    26 MB
> Records:     265,000
> Workstation: Pentium 133, 43 MB RAM
> Nertwork:    10Base-T (MDB in on a server)

> * This application will be ported to VB 5 Enterprise with an Access 97
> database file sometime in the next few months.  

> Thanks for any help.  

> Louis Wood