Error when executing access quries from vba project.

[jcgragav]

Hi,

I am facing an error and my query is not completed when executing from excel vba project.

I have written a vba pgm to create around 6 tables and access the table to create a dashboard kind of report.


in my script i am deleting all the tables which is already available in the db and i am creating the same tables.
in that my first table is creating around 20k records but it ends with an abort. so my vba script is not executing the other queries and all the script lines reading the tables got error due to the tables got deleted.

i think this is like a timwout issue while creating a 20k records in my first table. so all other tables are not created..

please help me. I will provide furthere information.

Thanks
Ragav

[ssanfu]

Why are you deleting the tables each time? Does the structure of the tables change between runs?
If not, instead of deleting the tables and re-creating them (which causes bloat), execute delete queries to clear the tables. (Still has bloat, but not as bad as deleting/re-creating tables).

Then all you have to do is run the append queries.

You should single step through the code to find out why it is aborting.....

[jcgragav]

Hi Steve,

I am getting an error: Run-time error 1004: Application-defined or "object-defined" error.

I tried deleting the records instead of table..

Here is what i am trying to do...
cnt.Execute ("DROP TABLE TBL_ABC")
cnt.Execute ("DROP TABLE TBL_ABCD")
cnt.Execute ("DROP TABLE TBL_ABCDEF")
cnt.Execute ("DROP TABLE TBL_ABCDEFGH")

but the TBL_ABC itslef not deleted and i am facing the 1004 run-time error.

Please advice.

thanks
ragav

[ssanfu]

To delete all records from a table:

cnt.Execute ("DELETE * FROM TBL_ABC"), dbfailonerror

Replace TBL_ABC with your table name.