Hallo to anybody how is able to help me with the problem.
Backround: I am designing a access 2002 database for a health company.
topic: I have one table where are client data is stored. At least 58000 Records.
I am starting out of a autogenerated formular 4 SQL scripts.
The first script deletes all data within the table.
The second script is the problem.
While run the script. Simple insert tableimp
select *
from *
The following error ocurre.
Run time error 4721..
Expected SQL statment 'insert' 'delete' ..
The problem ocurres only when the sql sting produces more than 72 records. Beneath the script is working fine.
Hoply somebody knows a lot more about VB than I do.
thanks in advance
Augustin
Backround: I am designing a access 2002 database for a health company.
topic: I have one table where are client data is stored. At least 58000 Records.
I am starting out of a autogenerated formular 4 SQL scripts.
The first script deletes all data within the table.
The second script is the problem.
While run the script. Simple insert tableimp
select *
from *
The following error ocurre.
Run time error 4721..
Expected SQL statment 'insert' 'delete' ..
The problem ocurres only when the sql sting produces more than 72 records. Beneath the script is working fine.
Hoply somebody knows a lot more about VB than I do.
thanks in advance
Augustin
