I am in a friendly debate with some co-workers... and my boss.
We use Access 2003 for the frontend (on workstations) as well as for
the backend (on a Dell PowerEdge running Windows 2000 server, SP4).
We have approx. 20 users *logged in* at any one time (over 300
userid's exist), but we have never run metrics to see how many on
average are accessing the database concurrently.
About once every few weeks, the database mysteriously becomes
corrupted.
One thing that seems pretty reliable is if my co-worker or I are in
design mode of a table and manually edit a record while someone else
is editing the same record via the frontend.
In addition, I thought that if I abnormally exited the program (CTRL-
ALT-DEL and kill the process while the program is loading, etc.), that
there would be a very good chance of corrupting the DB. Especially
(only?) if you killed it while it was accessing a record, before it
closed a recordset, etc.
Can anyone shed any light here? I have found several references
throughout this newsgroup, and even a Corruption FAQ: http://www.granite.ab.ca/access/corruptmdbs.htm
but I would really like to know if abnormal termination would/should
do it. Random testing so far has been unable to reproduce the desired
corruption. I even tried running the code, setting a breakpoint in
the middle of a record operation, then CTRL-ALT-DELing the process.
No corruption.
Help?
Thanks.
Mar 22 '07
42  2129 
rewriting a moderately complex MDB applicatino to SQL Server should
take a week. TOPS.
it is worth it for every every every situation
you should be using ADP instead of VB.net _CRAP_ though
ADP is a lot more cost efficient
On Apr 3, 5:55 pm, "(PeteCresswell )" <x...@y.Invalid wrote:
Per Doug:
We are re-writing the application with a dotNET front end and a SQL
Server back end.
Do you have good numbers on how much it cost to write the original app?
If so, it would be nice tb able to compare the new version's cost once it's
done.
--
PeteCresswell
MDB corruption is random
MDB can't be run over WAN, VPN, Wireless, Etc
ADP works great everywhere
Note that Tony Toews is a MDB _WUSS_ and should not be trusted for
anything.
It's like going to ask a 1st grader for financial advice
ADP uber alles!
Apr 3, 4:36 am, "Doug" <spamwo...@gmai l.comwrote:
We are re-writing the application with a dotNET front end and a SQL
Server back end.
I am just trying to test my hypothesis about the MDB corruption.
Thanks for all the input.
MDB is not useful for anything other than bloat
just use Access Data Projects; you can use a simple SCHEDULED
'Database Maintenance Wizard' in order to prevent problems; and it
won't prevent 24x7x364 usage
On Mar 26, 5:23 pm, "(PeteCresswell )" <x...@y.Invalid wrote:
Per Larry Linson:
neither
Access nor Jet are "appropriat e technology" for that kind of application.
Would that caveat extend to MS Access as a front end to an SQL Server DB - or is
it just for the back end?
--
PeteCresswell
re:
before it closed a recordset
DAVID
are you really still dealing with the DAO memory leak _CRAP_?
ADO you don't need to close jack shit; things go out of scope and it
works like it shoudl.
MDB and DAO have a ton of unnnecessary overhead-- for developers and
end users
On Mar 23, 6:18 am, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
"Doug" <spamwo...@gmai l.comwrote innews:11****** *************** *@y80g2000hsf.g ooglegroups.com :
In addition, I thought that if I abnormally exited the program
(CTRL- ALT-DEL and kill the process while the program is loading,
etc.), that there would be a very good chance of corrupting the
DB. Especially (only?) if you killed it while it was accessing a
record, before it closed a recordset, etc.
If it's in edit mode it's much more likely. Have two users (or two
instances of Access on the same machine) edit a memo field
simultaneously, and kill one or both instances of Access and you've
got a pretty good chance of corrupting the records (though not
necessarily the database). You don't even have to kill Access to
make it happen with the memo fields.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
wow David
I would be really really impressed-- but from my recollection of
Access 97? it crashed / corrupted ALL THE FRIGGIN TIME
so what you're saying is 97, 2000 and anything newer than 2000 is
subject to constant corruption?
why don't you use Access Data Projects, kid?
On Mar 23, 6:22 am, "David W. Fenton" <XXXuse...@dfen ton.com.invalid >
wrote:
"Doug" <spamwo...@gmai l.comwrote innews:11****** *************** *@n59g2000hsh.g ooglegroups.com :
I found several references (some from MS) stating that:
In my experience, since A2K was released, the biggest cause of
corruption is bad versions of Jet and Access. I've had only one
hardware problem (which didn't result in corruption) with Access
since about 2000, and that was with an A97 application.
But with A2K and higher, clients have had more corruption, maybe 1
client a year. One of my clients using A2K had problems when one
workstation got reverted to the release version of A2K -- that's
almost guaranteed to cause problems.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"Susie DBA [MSFT]" <su******@hotma il.comwrote in
news:11******** **************@ q75g2000hsh.goo glegroups.com:
why don't you use Access Data Projects, kid?
1. Because they create a gaping security flaw?
2. Because they use multiple connections and the nature and number of these
connections is undocumented and cannot be predicted or managed?
3. Because the use of SQL-Server application roles with ADPs is
undocumented, arcane and approaches the paranomral?
4. Because it seems that MS has abandoned ADPs?
5. All of the above?
--
lyle fairfield
Ceterum censeo Redmond esse delendam
Per Susie DBA [MSFT]:
>rewriting a moderately complex MDB applicatino to SQL Server should
take a week. TOPS.
it is worth it for every every every situation
you should be using ADP instead of VB.net _CRAP_ though
Sounds like you're talking about the back end as opposed to the front end.
To me, a "moderately-complex" application runs somewhere between 400 and 600 man
hours.
--
PeteCresswell
Doug, this looks like a fairly reliable way to corrupt an Access database: http://support.microsoft.com/?kbid=935370
Requires a couple of Windows Vista or Longhorn Server machines.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Doug" <sp*******@gmai l.comwrote in message
news:11******** **************@ y80g2000hsf.goo glegroups.com.. .
>I am in a friendly debate with some co-workers... and my boss.
[snip]
"Allen Browne" <Al*********@Se eSig.Invalidwro te in
news:46******** *************** @per-qv1-newsreader-01.iinet.net.au :
Doug, this looks like a fairly reliable way to corrupt an Access
database:
http://support.microsoft.com/?kbid=935370
Requires a couple of Windows Vista or Longhorn Server machines.
The key issue there seems to be SMB 2.0. Isn't there some way in
Vista to turn that off? I vaguely recall some report of a problem
with that in Access before. Anyone?
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
"David W. Fenton" <XX*******@dfen ton.com.invalid wrote:
>Doug, this looks like a fairly reliable way to corrupt an Access
database:
http://support.microsoft.com/?kbid=935370
Requires a couple of Windows Vista or Longhorn Server machines.
The key issue there seems to be SMB 2.0. Isn't there some way in
Vista to turn that off? I vaguely recall some report of a problem
with that in Access before. Anyone?
Yes, SMB 1.0 was a problem in the past although it only affected performance.
See the Disable Server Message Block (SMB) Signing section at http://www.granite.ab.ca/access/performancefaq.htm
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Arno R |
last post by:
Hi all
Yesterday I found a strange corruption-issue that I can't solve yet or actually point my finger at.
I converted an A97 app to A2k.
I have done this often enough so I didn't expect trouble here.
Conversion seems OK and I start the app. BUT . . .
Mainform doesn't work. Form comes up but none of the buttons react.
Why not? I go to design view and see that code is not compiled. (compile-option is active)
So I compile and go to normal...
|
by: Mark C. |
last post by:
The company I work for has been running Access 2000 on a Windows NT
server with Opportunistic Locking turned off on the server without
issue for almost a year. We have just switched to a Windows 2000 file
server with service pack 3 installed and are now experiencing at least
2 corruptions a day. The registry setting for Opportunistic Locking
that was on the Windows NT server does not exist on the Windows 2000
server so we can not make the...
|
by: Upendra Agnihotram |
last post by:
Hi,
I am having Client-Server Access application. The source db resides on
WinNT Server and some of the client systems are on Windows 2000
Professional. These days i am experiencing frequent corruption of the
source database (nearly 3 to 4 times a day) which is on NT Machine?.
Please let me know if there is any solution for this
--Upendra
Software Support Engineer
|
by: Doug Vogel |
last post by:
Hi All -
I have a client for whom I developed an Access 2000 database. The
database is split into 2 files - front-end (forms, queries, reports),
and back-end (tables). An .mde file has been made for the front end
file.
Recently, they have been noticing some "problems" with the system.
Basically this system creates invoices for their customers. They have
been noticing that some of the invoices are now "wrong", specifically
|
by: ship |
last post by:
Hi
We need some advice: We are thinking of upgrading our Access database
from Access 2000 to Access 2004.
How stable is MS Office 2003? (particularly Access 2003).
We are just a small company and this is a big decision for us(!) It's
not just the money it's committing to an new version of Access!
| | |
by: Robert Oschler |
last post by:
Need help with HEAP CORRUPTION and my MSVC 6 DLL
I have a MSVC 6 DLL that I've written. It is used heavily by a Delphi 6 app
I've written.
For two months everything has been working fine. Then I changed some things
in the code recently, and now I'm getting what looks like severe corruption
of the heap.
I am wondering if it is some strange interaction between the Delphi app and
|
by: ranjeet.gupta |
last post by:
Dear All
Is the Root Cause of the Memory corruption is the Memory leak, ??
suppose If in the code there is Memory leak, Do this may lead to the
Memory Corruption while executing the program ?
In nut shell, what is/are the realtion/s between the Memory Leak and
Memory Corruption.
Juts Theoritical Assumtion below:
|
by: =?Utf-8?B?UHVjY2E=?= |
last post by:
Hi, I'm using VS2005 and .net 2.0. I'm creating an application that has 3
forms. I want allow users to move forward and backward with the forms and
retain the data users have entered. I thought I'll make the inactive forms
invisible but this is creating a memory corruption problem when user close
the form2 or form3 and not the formMain.
My main form has a Next button which makes the main form invisible and
starts a new form which I'll...
|
by: Slez via AccessMonster.com |
last post by:
I have read many resources regarding corruption, and implemented as much as
possible to prevent it, but I have one user that encounders corruption of
their front end database, when no-one else does. Is there something on this
users station that could cause this? I'm just fishing for any ideas on
possible causes, so any suggestions / tips are appreciated!
--
Message posted via AccessMonster.com...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
