I would try to troubleshoot it by running it on 2003. Also, you could email the prorgam to yourself and see if that caused the problem. I believe the problem relates to having different versions of Access (2003 vs. 2007) in development. I suggest to test it in the user's environment. Mike-
--- In [email protected], "Garrett O'Brien" <[EMAIL PROTECTED]> wrote: > > Hope all will be safe, fun and memorial for everone this > Thanksgiving... > > Created a MSA program in MSO2007 using the MSO2003 compatibility mode. > > Copied (Ctrl-C, Ctrl-V) and shipped this program to my client via > email - I am operating with MSA2007 and they with 2003. When initially > opened the program gets through 2 of the 4 forms when a message > appears > that a table is missing (that is, the VBA cannot find the table). > > When they attempt to reopen the program in draft or production mode, > MSA2003 opens but not the program - and then MSA2003 closes (confirmed > this by having the task manager open during the process). > > When I work the original from my end (in MS2007 in MSO 2003 > compatibility) everything goes smoothly... no missing table, all data > is processed properly, no integrity or operational issues. > > Let me know if you need more information - otherwise... > > What gives? > > Garrett O'Brien >
