I don't agree with your proposed solution. You should issue an SQL
statement to delete all the records from the table. For example,
db.Execute("DELETE * from tblname")
to delete all the records from table 'tblname'.
Issue an append query to add the new records to 'tblname' from 'tblname1'
db.Execute("INSERT INTO tblname SELECT * FROM tblname1")
Since your using VB4 the syntax will differ somewhat. Check help.
And another tip ... don't use Macros ... use VBA code. Study up on your SQL
code as well.
>I have an Access-database with 8 tables. In one of the tables I have
>600000 recordes (70 Mb).
>The database is approximently 80 Mb. What is the best way to delete all
>data and reloade new one?
>I want to do everything from Visual Basic 4.0. For the moment I use
>'appAccess.Run' and the Access
>procedure call an Access macro doing select all, delete all and transfer
>text, but I rather want
>to do it this way: copy the table-definitions/table-structure, then
>delete/drop all tables, after
>that I want to recreate the tables with the copied
>table-definitions/table-structure and load
>the new data. Is it possible to copy the
>table-definitions/table-structure and how do I do it?