Search results

Thanks again for the reply Dave! Forgive my ignorance, but, is there a flag or property that gets set on a database or table handle I can check to see if its locked. Meaning that the subsequent SQL code will fail? If I had that I could sprinkle debug prints or message boxes all over this...

Thanks for the reply JHB! I did check that the lock settings were the same in all instances (Old MS2000, updated MS2000, and MS 2010). Just to be sure I ran through this test sequence: - Verified customer copy working (old MS2000) - Copied MDB and MDW files to new machine with MS 2010 -...

Thanks for the reply Dave! Locking is set OK, keep in mind this code has been working for years without any errors. The order screen has a "save" function, that function does a bunch of checks for bad data, then has wrk.BeginTrans - business math - save order - find out if on-hand...

MS Access 2000 error 3218 caused by a software update I have a client running an MS Access 2000 retail shop program written by a very clever fellow - its a very full-featured system! Its running on an aging XP machine. Which is starting to show signs of croaking soon. So the client asked me...