I am trying to set up a DTS package that will import Access data into a SQL table. I create a SQL Provider. I create a Microsoft Access link. I add Transform data between the two. When I right click on Transform data and choose Properties I get the following error:
mmc.exe Application Error
The instruction at "0x1b0416d1" referenced memory at "0x00000000". The memory could not be read.
I am given the option of clicking OK or Cancel.
When I click OK, I get the following error:
mmc.exe Application Error
The instruction at "0x4214049c" refereneced memory at "0x085784d8". The memory could not be written.
I am given the option of clicking Ok or Cancel. When I click OK, Enterprise Manager closes.
This sequence happens with any Microsoft Access database. I am using SQL Server 7.0 on a Windows 2000 Server, Service Pack 2.
Any help would be appreciated.
mmc.exe Application Error
The instruction at "0x1b0416d1" referenced memory at "0x00000000". The memory could not be read.
I am given the option of clicking OK or Cancel.
When I click OK, I get the following error:
mmc.exe Application Error
The instruction at "0x4214049c" refereneced memory at "0x085784d8". The memory could not be written.
I am given the option of clicking Ok or Cancel. When I click OK, Enterprise Manager closes.
This sequence happens with any Microsoft Access database. I am using SQL Server 7.0 on a Windows 2000 Server, Service Pack 2.
Any help would be appreciated.