I have about 15 users in my database and quite often I get error message
number 1206 "Could not find field 'Description'". Would this be related that
I haven't set yet edited record-locking = as soos as one user begins to edit
a record, no other user can make any changes to it until 1. user saves the
changes?
Joan Wild - 25 Mar 2006 15:15 GMT
That's often a sign of corruption. You should bakcup the mdb and then run
'compact and repair'.
If your users are all using the same copy of the database on the server, you
should split the database. Put the backend (tables/relationships) mdb on
the server, and give each user a copy of the frontend (all other objects)
mdb on their workstation. The frontend would contain links to the tables in
the backend.
Corruption references:
http://www.granite.ab.ca/access/corruption/symptoms.htm
http://allenbrowne.com/ser-25.html
http://www.rogersaccesslibrary.com/jerrywhittle/FixCorruptAccessDatabasev44.doc--Joan WildMicrosoft Access MVPLailukki wrote:> I have about 15 users in my database and quite often I get error> message number 1206 "Could not find field 'Description'". Would this> be related that I haven't set yet edited record-locking = as soos as> one user begins to edit a record, no other user can make any changes> to it until 1. user saves the changes?