Interesting about the ability to use UNC. I even created an incident with MS on that one, and was told no way. Of course, this was with Access 97. I...

Your users do not have the same share linked to the same path. If the FE is set up to find the BE at J:\MyDB\GoodStuff.mdb, then all users have to...

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...