intermittent #error in a notes field in MS Access
Posted on 2013-02-06
I have a ms access front end (2003) and a sql server 2005 back end. I have about 100 users. There is notes field on the main form. 3 or 4 users have reported that about once a week they see #error in the notes. The field is varchar(1000) in sql server and memo data type in the access linked table. The control source is just the database field , there is no calculating going on. Users access the front end with a mde file. Most of them get access through a remote desktop. The remote desktop server has windows 2008 server(32bit) on it. Only one record at a time seems to have this problem and only the one field. The default view is "single form" so they only see 1 record at a time.
Apparently this has been happening for a while but went unreported. Closing the application and reopening fixes it. And I think just navigating away and back also fixes but havn't confirmed that yet. When I say fixes I mean the regular notes show up. I have been unable to recreate the problem ever. 1 person said they were running the mde from their local computer, the rest from the remote desktop. I make updates to the mdb and create new mde's about once a month. I always compact and repair before making the mde.
All my googling for #error only turned up problems with calculations and corrupt db's. And as I said there is no caluclating happening. Corruption seems less likely since I have a sql server backend. Any suggestions?