Append query won't run on one PC - runs on all others.

[Dogbut]

I have an append query that is linked to an AS/400 table, and an Access table
using Access 2003. The design of my program uses a delete query to remove the
records from the destination table, and then runs the append query to replace
the records in the destination table with fresh data.

The program works fine - I have 10 years experience writing access programs.
I have distributed the program to 30 locations within the company I work for.
At one location, the program is installed on 4 PC's. The program works well
on 3 of the 4 PC's. The append query stalls on the 4th PC and will not append
ANY records.

I checked the AS/400 ODBC connections, table links, etc. through netmeeting,
and everything checked out okay. I can view the linked data within the tables,
and a regular query works just fine. When the append query starts, I get 1
bar on the progress bar, and the program stops rresponding.

Has anyone heard of this? Could this be due to a previous version of Access
2007 being installed and removed on the PC with the problem?

Please - any and all suggestions are welcome - I am lost on this one.

 

[Jerry Whittle]

When things work on one PC but not others, it's usually a permissions or
references issue. That's what I would check first. There's always an outside
chance of a virus or spyware problems also.

However you mentioned an uninstall of Access 2007. It's very possible that
something didn't get completely uninstalled. I know that Microsoft had
uninstaller/removal tools for previous versions of Office but I don't know
about 2007. Also tools like CCleaner can sometimes fix registry problems.
Unfortunately I've had a few cases where nothing but a wipe of the hard drive
and a complete reinstall of the OS and apps fixed a particular PC's problems.