I have quite a few desktop PC's that were getting incredibly old. I ordered some barebones kits and reloaded XP onto these machines since they were working okay, just old and slow. To give you an idea of age, I had to download and install service pack 3 on all these machines.
I reloaded Office 2007 on all these machines. I only have one db that acts as a front end to another JET db. Both db's reside in the same folder on the server. I set up the folder as a trusted location, and enabled all macros.
When one of the new PC's opens a scheduling form and enters a ship date and truck, they click a command button that has a macro attached to it. It's pretty straight-forward, open a query, then another one, etc. When it opens an append query, that's when we get the "action cannot be performed" message and when you click "okay" it lists which query and the error code 2950.
Funny thing is, everyone whose PC's I have not updated can run the form just fine with no errors. I can run it on a Windows 7 machine, the order desk person can run it on her PC with Vista, and the others with XP can run it as well. Just these new PC's have issues with it.
I've read a lot of the threads on this issue. I've even gone to the extreme of going to the server and explicitly giving each of the users full control over that folder. I'm at a loss and need to get these PC's working before heading South in a few days.
HELP!!