Error makes no sense - Urgent

[sam]

Hi, I have a A2000 dbase giving a strange error (seems
strange in it's timing anyway). When I try to open the
dbase it gives the error of "The microsoft jet database
engine stopped the process because you and another user
are atempting to change the same data at the same time"
As far as I know this error is normally associated with
record locking etc. bt I am getting the error when trying
to open the dbase. I then have the option of 'ok'
or 'help'. After 'ok' i just end up with access open but
not the dbase..... Any ideas??
Note: the dbase was on a server with multiple users
accessing it but was never split. it is now on a single
pc and giving the same error.

 

[RobFMS]

Here's an informative posting:
---------------------------------
http://groups.google.com/groups?hl=...&lr=&ie=UTF-8&oe=UTF-8&sa=N&as_qdr=all&tab=wg

Also, make sure you're uptodate with the latest patches for your version of
Access.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Eric Butts [MSFT]]

Hi Sam,

Sounds like corruption. Use Compact/Repair and/or JetComp.exe
see:http://support.microsoft.com/default.aspx?scid=kb;en-us;273956

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "sam" <[email protected]>
| Sender: "sam" <[email protected]>
| Subject: Error makes no sense - Urgent
| Date: Tue, 13 Apr 2004 20:53:46 -0700
| Lines: 13
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQh1BYVhQ6VxKvMTZGXMvHIHiE3kQ==
| Newsgroups: microsoft.public.access.setupconfig
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.setupconfig:29805
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.setupconfig
|
| Hi, I have a A2000 dbase giving a strange error (seems
| strange in it's timing anyway). When I try to open the
| dbase it gives the error of "The microsoft jet database
| engine stopped the process because you and another user
| are atempting to change the same data at the same time"
| As far as I know this error is normally associated with
| record locking etc. bt I am getting the error when trying
| to open the dbase. I then have the option of 'ok'
| or 'help'. After 'ok' i just end up with access open but
| not the dbase..... Any ideas??
| Note: the dbase was on a server with multiple users
| accessing it but was never split. it is now on a single
| pc and giving the same error.
|

 

[sam]

Thanks Guys, I think it may be a lost cause. I've tried
linking to the tables, compact & repair, opening
in 'safe' mode, shift key down, jetcomp.exe, read every
article i can find, pretty much everything i can think of
but have made no in-roads at all. Even running jetcomp I
get 'error in compacting' straight up.
Thanks anyways for your replies, much appreciated.