Stephen R. Zayko
szayko at secor.com
Tue Aug 12 17:07:54 CDT 2003
Mark: I am not sure what/how you are getting the error but I get a similar one when working with an mdb that links to ODBC data sources. Similar circumstances... I am the only user of the database (verified by firewall logs). Not every time you edit a record, but 60-80% of the time. This is my environment: FE = Access 2000 BE = ODBC datasource (MySQL or MS_SQL) DSN = system DSN Source of data to be edited can be 'linked table' or 'query of linked table' or form based upon either of those. When editing the contents of a field and then you move to another record: ________________________________________________________________________ ____ Write Conflict! This record has been changed by another user since you have started editing it. If you save the record you will overwrite the changes the other user made. Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes. _______________ _____________________ _________________ | Save Record | | Copy to Clipboard | | Drop Changes | --------------- --------------------- ----------------- ________________________________________________________________________ ___ The 'Save Record' button is ALWAYS disabled and you have to select the button to 'Drop Changes' Evil evil evil evil evil. I have worked around this by making everything 'unbound' but do not wish to open that entertaining debate right now. What I would like to do now is find out 1) What on earth is causing that error? 2) Why does it never let a user select 'Save Record' to just bullhead your way through changes? 3) What can I do as a developer to stop it from occurring? Stephen R. Zayko, P.E. SECOR International Inc. 2321 Club Meridian Drive, Ste E Okemos, MI 48864 (p) (517) 349-9499 ex24 (f) (517) 349-6863 (m) (517) 204-5136 szayko at secor.com www.secor.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Porter, Mark Sent: Tuesday, August 12, 2003 05:19 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Cannot open .mdb file Hi all, I have an .mdb file which I cannot open. The error is "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time" This file was recently recovered from a backup tape. The admins have verified that all users have access to the file. Nobody else is using this file, there is not even an .ldb file for it in the directory. I also cannot connect to it; I recieve the same error. Any ideas? Mark This transmittal may contain confidential information intended solely for the addressee. If you are not the intended recipient, you are hereby notified that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. If you have received this communication in error, please notify us immediately by reply or by telephone (collect at 907-564-1000) and ask to speak with the message sender. In addition, please immediately delete this message and all attachments. Thank you. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com