[AccessD] acNewRec

Mark Boyd MarkBoyd at McBeeAssociates.com
Tue Nov 18 11:59:00 CST 2003


Thanks Juan.  I'll check the user's machines to make sure these settings
are correct.

Mark

-----Original Message-----
From: MastercafeCTV [mailto:mastercafe at ctv.es] 
Sent: Tuesday, November 18, 2003 11:17 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] acNewRec

Check the config in Access 2002:

Default Open Mode : SHARED
Default RecordLocking : EDITED RECORD

When we install a new computer always check the main config from access
(report, general, advanced, etc.)

If this run, check in the main form if you used LOCK EDITED RECORD

Good luck

Juan

===========================================
MASTERCAFE SL - NIF B-82.617.614
www.mastercafe.com
Deleg. Asturias 
Tel 985.88.49.44 / 627.531.764
Fax 627.500.205
info at mastercafe.com
juan at mastercafe.com
Deleg. Madrid
Tel 627.474.285
cecilia at mastercafe.com
===========================================


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Boyd
Sent: martes, 18 de noviembre de 2003 17:03
To: AccessD at databaseadvisors.com
Subject: [AccessD] acNewRec


I have an Access2002 mdb that is being used by 5 users.

The front-end is located on each user's hard drive, while the linked
tables
are located in an Access2002 mdb on the network.

There haven't been any problems in the past month, but now users are
receiving the following error when adding a new record to a form: "Could
not
update. Currently locked".  The code is "DoCmd.GoToRecord, , acNewRec".

 

Any ideas?

 

TIA,

Mark Boyd

Sr. Systems Analyst

McBee Associates, Inc.

 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list