load problem from access database

[#1]

hi all

i  have a access database with 42,000 rows.

i defines odbc connection (becuase it gave error to ODE LB conenction )

it doesnt give error when i run the script

it updatese 1800 rows than waits after that it reaches 4500 rows and waits normally

it must be faster.

where i do something wrong?

thnaks

[#2 · Accepted solution]

i solved the problem.

if we do "select * from database " system will have low performance. so i selected only the fields that i need .