To help you avoid some of the more common and long-standing bugs in Access,
the page: http://allenbrowne.com/tips.html
contains a new section entitled, "Flaws in Access".
The section currently identifies 9 problem areas, with others to be added.
It includes a sample Access 2000 database to demonstrate several of the
flaws. If you have been working with Access, you will be aware of some of
them. Our aim is to prevent you grief by pin-pointing the rocks under the
surface.
Best wishes for your Accessing in 2004.
--
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.
Nov 12 '05
20 1641
Hi Steve. Thanks for your response.
I have only experienced this as a display issue.
The problem exists in A2000 (even with SP3), and A2002 (even with SP2), but
I am not seeing it in A2003.
Here is a temporary link example of the issue as I see it: http://allenbrowne.com/BadMemoFooter.zip
If you can show me an example that is more than a display issue, I am *very*
interested, and will take it up with Microsoft.
Thanks.
--
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.
"Steve Jorgensen" <no****@nospam. nospam> wrote in message
news:3i******** *************** *********@4ax.c om... On Wed, 31 Dec 2003 09:13:27 +0800, "Allen Browne" <Al*********@Se eSig.Invalid> wrote:
Hi Steve.
Yes, I had that issue in Access 2000, but could not repro. quickly in
A2003.Have you seen it in the current version? No, but it is definitely still a problem in A2002.
It was really a display issue where Access displayed the old data for a
memofield in the form footer section. As soon as you clicked in the field to edit it, the text box was updated, so there was no danger of overwriting
it. I've had the problem in both 2000 and 2002 where it actually writes to the wrong record, and is not just a display problem.
I'm interested if you can repro in A2003. Me too, but I don't have it. I could try it with the beta, but the
results won't be definitive.
Hi michka.
Appreciate your response, and can understand your perspective, and your
experience in internationaliz ation. From my perspective is is a bug, though
I am willing to reconsider.
I became aware of this issue when I developed a database for a client in the
UK some time back. When he received the database, he asked, "What's these
weird formats that force it to use dollars?" My copy did not display any
"weird formats" - just the word "Currency". For a developer, it's a bug.
The behaviour also contradicts the documentation which claims Currency will:
"... follow the settings specified in the regional settings of Windows
for negative amounts, decimal and currency symbols, and decimal
places."
--
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:3f******** @news.microsoft .com... Nice list, though one thing:
The "currency format" issue is NOT a bug. It is entirely by design and it MUST be this way. An application that turned 1000 US Dollars into 1000 Italian Lira is an app that was produced by a company that is going to go out of business.... think about.
This design was championed by the International Program Manager back in Access 2.0, and she was entirely right. I would highly recommend that this item be taken off of the list of bugs and put in a more appropriate list
of "issues to not trip over" as the current design is correct an any other design is an incredibly lame an ill-conceived notion.
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:3f******** **************@ freenews.iinet. net.au... To help you avoid some of the more common and long-standing bugs in Access, the page: http://allenbrowne.com/tips.html contains a new section entitled, "Flaws in Access".
The section currently identifies 9 problem areas, with others to be
added. It includes a sample Access 2000 database to demonstrate several of the flaws. If you have been working with Access, you will be aware of some
of them. Our aim is to prevent you grief by pin-pointing the rocks under
the surface.
On Wed, 31 Dec 2003 13:05:36 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote: Hi Steve. Thanks for your response.
I have only experienced this as a display issue. The problem exists in A2000 (even with SP3), and A2002 (even with SP2), but I am not seeing it in A2003.
Here is a temporary link example of the issue as I see it: http://allenbrowne.com/BadMemoFooter.zip
If you can show me an example that is more than a display issue, I am *very* interested, and will take it up with Microsoft.
Thanks.
I just attempted to repro the problem, and did not do so. The display problem
appeared immediately, but the behavior was a display problem only, as you
described. I'm reasonably certain, however, the problem did appear as I
described it in other cases. As I recall, the last system this happened on
was using linked tables to a SQL Server back-end, so that could be part of the
equation.
Allen, it seems to me that the way this is handled may be difference between
a database that has data and one that doesn't. If I have the database full
of values in US dollars, changing the format to Pounds but leaving the
numbers the same would be a problem. However, if I'm distributing a blank
database then it would be nice to have the formatting change since any
numbers added would be in the currency of the computer that the app is
running on.
--
Wayne Morgan
Microsoft Access MVP
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:3f******** **************@ freenews.iinet. net.au... Hi michka.
Appreciate your response, and can understand your perspective, and your experience in internationaliz ation. From my perspective is is a bug,
though I am willing to reconsider.
I became aware of this issue when I developed a database for a client in
the UK some time back. When he received the database, he asked, "What's these weird formats that force it to use dollars?" My copy did not display any "weird formats" - just the word "Currency". For a developer, it's a bug.
The behaviour also contradicts the documentation which claims Currency
will: "... follow the settings specified in the regional settings of
Windows for negative amounts, decimal and currency symbols, and decimal places."
-- 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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in message news:3f******** @news.microsoft .com... Nice list, though one thing:
The "currency format" issue is NOT a bug. It is entirely by design and
it MUST be this way. An application that turned 1000 US Dollars into 1000 Italian Lira is an app that was produced by a company that is going to
go out of business.... think about.
This design was championed by the International Program Manager back in Access 2.0, and she was entirely right. I would highly recommend that
this item be taken off of the list of bugs and put in a more appropriate list of "issues to not trip over" as the current design is correct an any other design is an incredibly lame an ill-conceived notion.
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:3f******** **************@ freenews.iinet. net.au... To help you avoid some of the more common and long-standing bugs in Access, the page: http://allenbrowne.com/tips.html contains a new section entitled, "Flaws in Access".
The section currently identifies 9 problem areas, with others to be added. It includes a sample Access 2000 database to demonstrate several of
the flaws. If you have been working with Access, you will be aware of some of them. Our aim is to prevent you grief by pin-pointing the rocks under the surface.
On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:
Would you consider some "Operation should use updatable query" items
for your list? For example there is one in this category where a table
is updated with the results of a totals query.
-Tom.
To Repro:
Northwind database.
Create new query QtySoldPerProdu ct:
SELECT [Order Details].[ProductID], Sum([Order Details].[Quantity]) AS
SumOfQuantity
FROM [Order Details]
GROUP BY [Order Details].[ProductID];
Create new query:
UPDATE QtySoldPerProdu ct INNER JOIN Products ON
QtySoldPerProdu ct.ProductID = Products.Produc tID SET
Products.Reorde rLevel = [SumOfQuantity]; To help you avoid some of the more common and long-standing bugs in Access, the page: http://allenbrowne.com/tips.html contains a new section entitled, "Flaws in Access".
The section currently identifies 9 problem areas, with others to be added. It includes a sample Access 2000 database to demonstrate several of the flaws. If you have been working with Access, you will be aware of some of them. Our aim is to prevent you grief by pin-pointing the rocks under the surface.
Best wishes for your Accessing in 2004.
And THIS is the crux. If I have to choose between a pattern that will
corrupt existing data and a patern that will confuse developers who ship
internationally for the first time, I would have to be a a fool to want the
latter rather than the former.
It is NOT a bug -- it is 100% PEBCAK. Please reconsider.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message
news:Ak******** *******@newssvr 16.news.prodigy .com... Allen, it seems to me that the way this is handled may be difference
between a database that has data and one that doesn't. If I have the database full of values in US dollars, changing the format to Pounds but leaving the numbers the same would be a problem. However, if I'm distributing a blank database then it would be nice to have the formatting change since any numbers added would be in the currency of the computer that the app is running on.
-- Wayne Morgan Microsoft Access MVP
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:3f******** **************@ freenews.iinet. net.au... Hi michka.
Appreciate your response, and can understand your perspective, and your experience in internationaliz ation. From my perspective is is a bug, though I am willing to reconsider.
I became aware of this issue when I developed a database for a client in the UK some time back. When he received the database, he asked, "What's
these weird formats that force it to use dollars?" My copy did not display any "weird formats" - just the word "Currency". For a developer, it's a bug.
The behaviour also contradicts the documentation which claims Currency will: "... follow the settings specified in the regional settings of Windows for negative amounts, decimal and currency symbols, and decimal places."
-- 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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in message news:3f******** @news.microsoft .com... Nice list, though one thing:
The "currency format" issue is NOT a bug. It is entirely by design and it MUST be this way. An application that turned 1000 US Dollars into 1000 Italian Lira is an app that was produced by a company that is going to go out of business.... think about.
This design was championed by the International Program Manager back
in Access 2.0, and she was entirely right. I would highly recommend that this item be taken off of the list of bugs and put in a more appropriate
list of "issues to not trip over" as the current design is correct an any
other design is an incredibly lame an ill-conceived notion.
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with no warranties, and confers no rights.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message news:3f******** **************@ freenews.iinet. net.au... > To help you avoid some of the more common and long-standing bugs in Access, > the page: > http://allenbrowne.com/tips.html > contains a new section entitled, "Flaws in Access". > > The section currently identifies 9 problem areas, with others to be added. > It includes a sample Access 2000 database to demonstrate several of the > flaws. If you have been working with Access, you will be aware of
some of > them. Our aim is to prevent you grief by pin-pointing the rocks
under the > surface.
Well, that's certainly a severe annoyance and a difference from ASNI behavior,
but it is a design limitation, not a bug. I'm not saying it's unimportant,
but it seems to me that a list that includes such items would be a different
and vastly larger list. Perhaps, now would be a good time to start a new
Access annoyances thread, so we can chat about things like this and how to
best work around them.
On Wed, 31 Dec 2003 06:53:30 -0700, Tom van Stiphout <to*****@no.spa m.cox.net>
wrote: On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne" <Al*********@S eeSig.Invalid> wrote:
Would you consider some "Operation should use updatable query" items for your list? For example there is one in this category where a table is updated with the results of a totals query.
-Tom.
To Repro: Northwind database. Create new query QtySoldPerProdu ct: SELECT [Order Details].[ProductID], Sum([Order Details].[Quantity]) AS SumOfQuantit y FROM [Order Details] GROUP BY [Order Details].[ProductID];
Create new query: UPDATE QtySoldPerProdu ct INNER JOIN Products ON QtySoldPerProd uct.ProductID = Products.Produc tID SET Products.Reord erLevel = [SumOfQuantity];
To help you avoid some of the more common and long-standing bugs in Access, the page: http://allenbrowne.com/tips.html contains a new section entitled, "Flaws in Access".
The section currently identifies 9 problem areas, with others to be added. It includes a sample Access 2000 database to demonstrate several of the flaws. If you have been working with Access, you will be aware of some of them. Our aim is to prevent you grief by pin-pointing the rocks under the surface.
Best wishes for your Accessing in 2004.
After reflection, the page regarding the currency format has been relocated
under "traps" rather than "flaws".
I accept your argument that this is probably by design, as it is unlikely
that this behaviour could arise spontaneously (i.e. as a bug).
I do not accept that it is an appropriate design choice to have Access
tampering with the properties we set.
--
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.
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in
message news:3f******** @news.microsoft .com... And THIS is the crux. If I have to choose between a pattern that will corrupt existing data and a patern that will confuse developers who ship internationally for the first time, I would have to be a a fool to want
the latter rather than the former.
It is NOT a bug -- it is 100% PEBCAK. Please reconsider.
-- MichKa [MS] NLS Collation/Locale/Keyboard Development Globalization Infrastructure and Font Technologies
"Michael (michka) Kaplan [MS]" <mi*****@online .microsoft.com> wrote in message news:3f******** @news.microsoft .com... > Nice list, though one thing: > > The "currency format" issue is NOT a bug. It is entirely by design
and it > MUST be this way. An application that turned 1000 US Dollars into
1000 > Italian Lira is an app that was produced by a company that is going
to go > out of business.... think about. > > This design was championed by the International Program Manager back in > Access 2.0, and she was entirely right. I would highly recommend
that this > item be taken off of the list of bugs and put in a more appropriate
list of > "issues to not trip over" as the current design is correct an any other > design is an incredibly lame an ill-conceived notion. > > > -- > MichKa [MS] > NLS Collation/Locale/Keyboard Development > Globalization Infrastructure and Font Technologies > > This posting is provided "AS IS" with > no warranties, and confers no rights.
"Allen Browne" <Al*********@Se eSig.Invalid> wrote... After reflection, the page regarding the currency format has been
relocated under "traps" rather than "flaws".
Cool.
I accept your argument that this is probably by design, as it is unlikely that this behaviour could arise spontaneously (i.e. as a bug).
Probably? <sigh>
I have seen the code, and I have had lunch with the woman who spec'ed the
original design. She was right.
I do not accept that it is an appropriate design choice to have Access tampering with the properties we set.
Um, it does not. Try creating the table, changing the settings, viewing the
changed prop, changing the settings back, and then viewing the prop. It
changes back to the original "Currency" setting!!!
You will see that ACCESS goes out of its way to keep people from trying to
change application behavior out from under it due to a simple change in
config settings. ACCESS is not tampering with anything; it goes out of its
way to respect the settings!
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies
This posting is provided "AS IS" with
no warranties, and confers no rights.
G'day
Regarding: losing data when closing a form
What about closing the form with the Close command on the menu bar?
Would it cause the problem?
Thanks
NB This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Marc Nadeau |
last post by:
Hi, I have a new project that consist of transfering a JD Edwards
Database to an MS Access database. I am just starting to learn how
those 2 databases works. What is the general idea behind this??
Outputing the data to a text file and read it? I just need the basic
concept please.
Thank you very much!
Marc-Andre
|
by: B Moor |
last post by:
Hello,
I am quite bogged down with this problem and would like some tips/help
if any one has any.
Thanks in advance.
The Problem
-----------
This system initially seemed quite stable for a few weeks but now,
|
by: Brent Burkart |
last post by:
I am trying to send an email using SMTP server through IIS. I am recieving
the following error.
Access is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access is denied.
|
by: ASP.Confused |
last post by:
The old message looked a little stale, so I am re-posting it here. Anybody
have any ideas of what I could do?!? The previous responses to this
question are below. If you want to look at the original question, the
subject line is:
ADODB.NET and "Access Denied"
I have an ASP.NET page writtein in VB that uses ADODB. I just had to
|
by: M |
last post by:
I installed the Visual Basic .NET Resource Kit.
When I click 'Visual Basic .NET Resource Kit'
the page
at 'http://localhost/VB.NETResourceKit/Welcome.aspx'
show:
Server Error in '/VB.NETResourceKit' Application.
-----------------------------------------------------------
---------------------
Server cannot access application directory 'D:\Program
| |
by: TC |
last post by:
I'd like to open a discussion about the state of the industry. For the
past year, I've been unable to find competent Access developers
available for hire. I'm worried about that.
I think there's great demand right now, and that's keeping the good
developers busy, but that's not enough to explain the situation.
Whenever I post an Access job, I get lots of responses from .NET
developers, back-end database people, and web developers. They...
|
by: johnvon |
last post by:
Can it be done, and if so, how?
Thanks!
John
|
by: dinoo |
last post by:
I did not find the right forum to post this issue, please excuse me for this.
But I need the help here very badly.
I am having a Windows Service in .NET which is accessing a MDB file which is
kept on the network drive. If I run the code as a Windows Application I can
access the database file. BUt when I run the Windows Service I get following
error-
"The Microsoft Jet database engine cannot open the file...
|
by: Christopher |
last post by:
I am surprised this hasn't come up for me more in the past, but the
situation is:
I need to have an interface that is usable for all
I need to have an interface that is only usable for some
I do not really know of a good way to achieve this. If I use friend
functions, I can no longer make methods virtual, right?
Example:
|
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: 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: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |