Delete Records In Table

[GregSmith]

I have a table called servers that I import data into.
After you exit the database, I would like to delete all the records from the servers table.

Any ideas on how to do this? Code examples would be great!!

Thanks in advance...

 

[GregSmith]

Here is the code:

DoCmd.RunSQL "Delete FROM [YourTableName]"

 

[Rob.Mills]

When I need to delete multiple records I use a delete query. Then you can use this code:

DoCmd.OpenQuery "QueryName"

 

[GregSmith]

Does any know how to do a compact and repair database within VBA Code?