You've probably done this, but...have you checked the rights on the non-core tables?
Crystal Hawk // Technical Manager Williams Lea at McCarter & English, LLP Four Gateway Center, 100 Mulberry Street, Ground Floor // Newark, New Jersey 07102 Direct: T 973-849-4202 Main: T 973-622-4444 // F 973-624-7070 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Garrett O'Brien Sent: Wednesday, February 18, 2009 3:08 PM To: [email protected] Subject: [Access VBA Central] Same program, different results... Sent a client a MDB copy of the MS Access program built for them. The database has a refresh process to update a set of core tables from another system through controlled processes. When we both run the program with the same data used to process the refresh (he on his and me on mine), both our copies populate the core tables properly. Clearing of the data from non-core tables works just as fine as well. The problem comes with the population of the non-core tables - my copy does just fine on my machine but his copy will populate but misses a bunch of records... I have compared both databases at the programming as well as at the data level using a comparison program and the programming is the same in both programs... just the non-core tables had any differences... Has anyone had a similar experience? Could something in his machine be causing the MSA program to 'burp' or 'skip' through the process when it is running???... Garrett [Non-text portions of this message have been removed] This email message from the law firm of McCarter & English, LLP is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. [Non-text portions of this message have been removed]
