Connecting to Oracle is a nasty piece of work, at best. Can you gain access to the SQL Server? Log in on the server and troubleshoot the ODBC connection using...

I agree with Mark if it is a large field, but 850 characters is not a large field. I suspect there may be some kind of hidden or special character...

I have the same problem with a remote Oracle DB that I download from nightly. I think it has to do with loosing the connection and DTS cannot detect that...

I want to defend Access 2003. It is an excellent product, and can connect to SQL Server by making a Project file, rather than linking. A Project file uses built...

None of you are helping the original poster! He needs our help now!

John - Quick! Run out and by "Open Heart Surgery For Dummies" and read chapter 8, "That Floppy...

One problem with linked tables rather than a Project file is performance. We see a markable improvement with performance if we use a Project DB. One example is a query...

TMSmith is right, but may not have given you enough information.

To fix this, remove the link and reestablish it. Access will ask you to select a unique record identifier....

StarPrint has some great docimentation tools. they are reasonabily priced (hey, I got my boss to by one for me!) and there are mutiple modules, so you only need to...

Security permissions maybe? Check how your DTS connection is configured. It may not have permissions to read one or both of the tables.

I am very aware of the need, not just in Srilnka, but in all the countries that were hit.

I must question your legitimacy, if you are true, then you have...

I think it has to do with the remote system dropping the ball and not returning a response. I have played with the different time outs in the ODBC connection,...

I can't help you on why it hangs. I have the same problem when I am importing from a Teradata DB. My 'solution' is to schedule another job to check...

The real issue is that the DTS import defines an Access DateTime field as a SQL DateTime data type when it creates the table. You need to modify the SQL...

Thanks for all the tips. I know it is not a timing issue, because I can enter debug and wait as long as i wish, it still will not find...

It also may be a mapped drive problem. When you run a DTS package from your system, it runs on your system and uses your client's mapped drives. The server...