If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subforms crash using ODBC
A97, Win XP
I have a form with two subforms. This form crashes Access (the "Send Error Report" kind of crash) when it's opened. Before yesterday, the queries on which the subforms are based were based on linked tables - linked to another Access database. I changed them to be linked directly to our accounting software via ODBC. The software is Timberline and have about 30 other mdb's that use Timberline's ODBC driver without issue. I changed the tables like this: Imported three tables via ODBC to replace the three Access linked tables that I wanted to delete. Changed all the queries to refer to those tables. Changed all the formulas in calculated controls on the forms to reference the new tables. Deleted the old tables. When I remove the two subforms, the form opens with no error. If either of the subforms are present, it will crash. I can open the subforms without it crashing, but obviously this shows all records. Nevertheless, I think it's odd that subforms open directly, but not when they're a subform on another form. All the underlying queries also run without error. I tried recreating the subforms from scratch and adding them to the parent form, but I got the same results. Can anyone suggest where else I might look? Thanks, -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office XP Setup for Access - ODBC Error 6 - HELP!!!!!!!!! | Shirl | Setup, Installing & Configuration | 2 | January 8th, 2005 08:23 PM |
ODBC Error 3423 | Kevin | General Discussion | 0 | December 14th, 2004 07:59 PM |
Subforms | damejennifer | New Users | 1 | December 1st, 2004 03:42 AM |
One-to-One Relationships and Subforms | Glen Richards | General Discussion | 2 | November 15th, 2004 08:45 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |