Hi All
I have a database which access data in our accounts system by using a ‘pass through’ query and odbc. This all worked fine until we changed servers. This changed the odbc reference. Not a problem really, just changed the database to the new reference and all was fine… except for a few users. For them, when they go into forms that use the pass through query they get errors because the query does not seem to work. The really weird thing is that to fix this all I have to do is open the form in design view and open the form’s VBA code, immediately close it again, return to form view and all works! Incidentally, if I open the query itself it seems to work but the forms still don't work until I go through the procedure I've mentioned.
If the same users close the database and go back in then it’s back to square one.
There is no obvious difference in the setup of those who have the problem and those who don’t.
I am at a loss as to how to fix this. :banghead:.Does anyone have any ideas?
Thanks
Colin
I have a database which access data in our accounts system by using a ‘pass through’ query and odbc. This all worked fine until we changed servers. This changed the odbc reference. Not a problem really, just changed the database to the new reference and all was fine… except for a few users. For them, when they go into forms that use the pass through query they get errors because the query does not seem to work. The really weird thing is that to fix this all I have to do is open the form in design view and open the form’s VBA code, immediately close it again, return to form view and all works! Incidentally, if I open the query itself it seems to work but the forms still don't work until I go through the procedure I've mentioned.
If the same users close the database and go back in then it’s back to square one.
There is no obvious difference in the setup of those who have the problem and those who don’t.
I am at a loss as to how to fix this. :banghead:.Does anyone have any ideas?
Thanks
Colin