Reply to thread

Message: [QUOTE="Eric Isaacs, post: 2012459"] I've posted some questions on other threads on this topic, but thought I should repost the answer to make it more promenent. I've determined that JET 4.0 sp7 has broken old code that I've been using for years. Specifically, I'm getting Error 3001 - "Invalid Argument" when doing a tabledefs.append and I've also determined that it causes Error 3219 - "Invalid Operation" when doing a querydefs.append. This is occuring with code that is referencing DAO 3.6 at least. There are a number of other posts I've seen in the newsgroups that have been showing similar errors. No one has specified in these posts if they have applied JET 4.0 sp7 or not. I also understand from another post on the subject that Windows 2000 sp4 includes the JET 4.0 sp7 patch. Applying the Windows 2000 sp4 will break the same code. I have applied the sp4 patch on my Win2k machine and the Win XP - JET 4.0 sp4 patch to my two machines. Only after having applied these patches did the code break. Before I patched my xp machine, my code was working there and not working on my Win2k machine that I had patched. Only after applying the patch and rebooting did the problem start to occur on my Win XP machine too. If you have any control over your user's machines, I wouldn't recommend updating to Win2k sp4 or JET 4.0 sp7 for the time being. I'll post code for confirmation of this issue in a post that will follow on this thread. [/QUOTE]