Ok, I'm not an Access expert. Here is the issue. I have Access database on server. Five computers on the network have to access the database. On the 5 computers Access 1999 is installed. When accessing the database from 3 of the 5 computers I get the error (when going into a Word doc that utilizes the database {i guess}) "runtime error 2424, the expression u entered has a field control or property name that Access can't find". Then at the bottom, debug, etc. I'm at wits end, the IT gal says its "impossible" that I am getting the error on just the 3 it should be happening on all 5 since the database is the same. She wants to create a new database for $150 (not a big deal, but I am going to lose alot). Unfortunately the only backup I have is months old. I have repaired and compacted the database without any problem. Reinstalled Access on all 5 and confirmed that there is only one database being accessed. Is this scenario possible? She seems someone miffed herself. Thanks!!!!
HELP- thanks!! Database issues
- Thread starter glens1234
- Start date
- Local time
- Today, 11:33
- Joined
- Aug 30, 2003
- Messages
- 36,270
Possible that an application will work on one PC and error on another? Sure. The cause I've seen is reference problems:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
sorry, 97. thanks! also the it guy said it could be an issue with xp profess. updates. he's thinking that the 3 "broken" comps. may have a different updates. i checked all and they all are set to "auto" update and the updates in add/remove in control panel are all dated the same with the same reference nubmer.
- Local time
- Today, 19:33
- Joined
- Sep 12, 2006
- Messages
- 15,987
when you click debug it will take you into the code at the line causing the error. As paul says. the first thing to check is the database dll references.
if the error arises when going into word, its more likely that different users have different versions of word, and this may be causing the problem. if the database expects to find word97, and the 3 machines have a later/different verison of word, that may be the issue - and i dont think that will be fixed with references
it should be fixed by splitting the database though, so each user has their own dbs, rather than all using the same copy on the network
if the error arises when going into word, its more likely that different users have different versions of word, and this may be causing the problem. if the database expects to find word97, and the 3 machines have a later/different verison of word, that may be the issue - and i dont think that will be fixed with references
it should be fixed by splitting the database though, so each user has their own dbs, rather than all using the same copy on the network
