473,320 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Flaws in Access (resource)

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 #1
20 1607
Nice list Allen, thank you.

--
Wayne Morgan
Microsoft Access MVP
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
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".

Nov 12 '05 #2
Thanks Allen,

I would add another issue to the "Writing the wrong record". Besides the
"Bookmark bug", there is a bug that exists in Access 2000 and 2002 that does
not seem to have been fixed in any service pack, and the workaround shown on
Microsoft's support page does not work.

The problem is when you have editable controls in the header and/or footer of
a form. If you edit one of these controls, then click on another row in the
continuous section, the new record's data is not displayed in the
header/footer control. Furthermore, if you type anything into that control,
it writes to the other record.

The only work-around I've ever gotten to work is to execute the .Requery
method on every control that could be effected from the form's Current event
handler.

On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:
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.


Nov 12 '05 #3
Allen,
Very useful info, thanks
BTW: Something 'buggy' with your dates?
It is still 2003 here ... <grin>
Flaws in MS Access
Provided by Allen Browne, January 2004

Arno R
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:3f**********************@freenews.iinet.net.a u... 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 #4
Perhaps it _is_ already 2004 on the clock/calendar in Australia?
"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
Allen,
Very useful info, thanks
BTW: Something 'buggy' with your dates?
It is still 2003 here ... <grin>
Flaws in MS Access
Provided by Allen Browne, January 2004
Arno R
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:3f**********************@freenews.iinet.net.a u...
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 #5
> Perhaps it _is_ already 2004 on the clock/calendar in Australia?

No, not yet on my (world) clock/calendar ...
In Sidney it's about 10 AM now (12-31-2003)

Arno R

Nov 12 '05 #6
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?

It was really a display issue where Access displayed the old data for a memo
field 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'm interested if you can repro in A2003.

--
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:8t********************************@4ax.com...
Thanks Allen,

I would add another issue to the "Writing the wrong record". Besides the
"Bookmark bug", there is a bug that exists in Access 2000 and 2002 that does not seem to have been fixed in any service pack, and the workaround shown on Microsoft's support page does not work.

The problem is when you have editable controls in the header and/or footer of a form. If you edit one of these controls, then click on another row in the continuous section, the new record's data is not displayed in the
header/footer control. Furthermore, if you type anything into that control, it writes to the other record.

The only work-around I've ever gotten to work is to execute the .Requery
method on every control that could be effected from the form's Current event handler.

On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne"
<Al*********@SeeSig.Invalid> wrote:
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.

Nov 12 '05 #7
You're right: I did not anticipate actually making these pages live until
2004, but managed to output them yesterday.

Good catch.

--
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.

"Arno R" <ar****************@tiscali.nl> wrote in message
news:3f**********************@dreader2.news.tiscal i.nl...
Allen,
Very useful info, thanks
BTW: Something 'buggy' with your dates?
It is still 2003 here ... <grin>
Flaws in MS Access
Provided by Allen Browne, January 2004
Arno R
"Allen Browne" <Al*********@SeeSig.Invalid> schreef in bericht
news:3f**********************@freenews.iinet.net.a u...
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.

Nov 12 '05 #8
On Wed, 31 Dec 2003 09:13:27 +0800, "Allen Browne"
<Al*********@SeeSig.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 memo
field 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.
Nov 12 '05 #9
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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
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 #10
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.com...
On Wed, 31 Dec 2003 09:13:27 +0800, "Allen Browne"
<Al*********@SeeSig.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.

Nov 12 '05 #11
Hi michka.

Appreciate your response, and can understand your perspective, and your
experience in internationalization. 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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
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.

Nov 12 '05 #12
On Wed, 31 Dec 2003 13:05:36 +0800, "Allen Browne"
<Al*********@SeeSig.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.
Nov 12 '05 #13
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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Hi michka.

Appreciate your response, and can understand your perspective, and your
experience in internationalization. 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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
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.


Nov 12 '05 #14
On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne"
<Al*********@SeeSig.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 QtySoldPerProduct:
SELECT [Order Details].[ProductID], Sum([Order Details].[Quantity]) AS
SumOfQuantity
FROM [Order Details]
GROUP BY [Order Details].[ProductID];

Create new query:
UPDATE QtySoldPerProduct INNER JOIN Products ON
QtySoldPerProduct.ProductID = Products.ProductID SET
Products.ReorderLevel = [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.


Nov 12 '05 #15
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***************@newssvr16.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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
Hi michka.

Appreciate your response, and can understand your perspective, and your
experience in internationalization. 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*********@SeeSig.Invalid> wrote in message
news:3f**********************@freenews.iinet.net.a u...
> 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.



Nov 12 '05 #16
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.spam.cox.net>
wrote:
On Tue, 30 Dec 2003 19:41:17 +0800, "Allen Browne"
<Al*********@SeeSig.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 QtySoldPerProduct:
SELECT [Order Details].[ProductID], Sum([Order Details].[Quantity]) AS
SumOfQuantity
FROM [Order Details]
GROUP BY [Order Details].[ProductID];

Create new query:
UPDATE QtySoldPerProduct INNER JOIN Products ON
QtySoldPerProduct.ProductID = Products.ProductID SET
Products.ReorderLevel = [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.


Nov 12 '05 #17
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.

Nov 12 '05 #18
"Allen Browne" <Al*********@SeeSig.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.

Nov 12 '05 #19
NB
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
Nov 12 '05 #20
You do receive a suitable message if you use File | Close.

It is the Close action (macro) or method (DoCmd.Close code) that loses your
entry silently.

If you use a custom toolbar, it will depend which approach you take. Easy
enough to test.

--
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.

"NB" <ni******@lycos.com> wrote in message
news:5c**************************@posting.google.c om...
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

Nov 12 '05 #21

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
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...
1
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...
2
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...
0
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...
0
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...
57
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...
14
by: johnvon | last post by:
Can it be done, and if so, how? Thanks! John
0
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...
4
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...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.