Hi,

I have set all the necessary permission on the server and
have also installed MS Access on the server.

Within the VB code I execute 2 DTS packages

1) deletes(drops) the Access tables. This executes fine
and I can see that it drops the tables.
2) Create (Access tables) in SQL and then imports the
data. This step creates the Access tables in SQL but fails
to import the data. Tables are empty.

Note that if the DTS packages are executed manually on the
server it runs successfully.

Why does it not import the Access data into the SQL
tables when executed in VB? Any help will be much
appreciated.

Thanks

J