[AccessD] Cannot open .mdb file

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



More information about the AccessD mailing list