I am a director of the Denver Area Access users group. Each month, I see and hear the problems people encounter developing applications in Microsoft Access. I also belong to a newsgroup of programmers that help each other out with problems. The following are samples of some of the 40 plus email messages that appear in this newsgroup daily. I include this discussion because I feel it might give you a sense of some of the problems developers are having. Note that a lot of these email messages are never answered.
Date: Fri, 10 Apr 1998 13:54:53 -0400
From: Brian McDermott
Subject: Access running but not responding...
Date: Fri, 10 Apr 1998 13:54:53 -0400Further to my earlier post about Access being too slow, another phenomenom I’m experiencing is Access tying up the machine. If I look at the task manager under win 95 or win nt, Access is recorded as not responding. this is despite the fact that it is running. I know this because the status bar is being regularly updated.
Access won’t minimize and the screen is not being redrawn properly. It is acting like a shocking hog!
Can anyone explain why this behaviour and what can be done about it?
Date: Tue, 7 Apr 1998 16:47:00 -0500Has anyone had problems with Access 97 closing the database minimizing itself and not closing. Even maximizing going to file, exit it still minimizes and stays open. It always closes the database. this is happing on 5 different computers. I am getting file lock errors and I can't access my data.
Any ideas
Hi folks,
I managed to get rid of the automation error by using a backup of the database from yesterday. I checked the database and everything was fine. I left my computer for a while and when I came back the automation error came back.
The database was not changed!!
What the hell is going on?
Date: Fri, March 25, 1998 13:36:07 -0500
From: Dara Kelly
Subject: Re: Repeat please help
Date: Fri, 3 Apr 1998 13:36:07 -0500Hi
I'm very sorry to repeat a question - but I am absolutely desperate to get this database open as I have no other copy and its no exaggeration to say my job could depend on it! So please if anyone has ANY ideas on this, or even on changing database permissions, or where I can find help, I'll happily marry you and have your children
Original question…
I have an Access 97 database which I backed up onto our Novell server minus its LDB file some time ago. My hard disk subsequently died so now this is the only copy I have. When I try to open it I get the following error:
"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 is Error 3197 according the the accompanying Help message but Microsoft's web site has failed to provide any more details. I've tried importing the records into an existing database but it gives the same error. I also tried opening the file in Exclusive mode and it tells me I don't have the right permissions. Can someone tell me how I can give myself the right permissions? I have copied the file from the NetWare server back to my hard disk in the meantime.
I have tried importing the records into a new database file but again I get the error message.
Thanks for ANY HELP at all!
At 12:12 PM 4/3/98 -0600, you wrote:
>Careful who you lump into IS. I think you are one of those terrible
>Power Users that give us programmers so many problems.... :)
>
<snip>>Just ranting
But if one of your DBA’s came to you and asked for another 64 MB of RAM for a machine running NT with 64 MB, would you give them a hard time?
Date: Thu, 8 Jan 1998 23:00:19 -0800
From: Bharat Ahluwalia
Subject: Need help on error 3197 -
Hi
I have been facing a problem in my access database. Every once in a while I get an error saying "The Microsoft JET database engine stopped the process because you and another user are attempting to change the same data at the same time."
I know this is a memo field problem and that is what worries me. I have another database application in which I have got far more memo fields and I have not got this error so far. The only difference that I can see is that in the first application I am entering data through Access forms where as in the second I am doing it through code. Do you think this could make a difference?
I would really appreciate it if you could provide any insight on this problem.
PS I know that Jet 3.51 sort of fixes the problem but still it would be great if I could know why it was happening.