problems with calcs in Access

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

is there a general problem with doing calcs in Access?

there is a woman in the office here that is trying to derail the use of
Access for the database and she claims it has a lot of problems with
processing calculations correctly, she's spouting all kinds of heresay that
major companies have dumped it in favour of other programs that apparently
work better

i'm thinking this is a load of #$#$%

yes?
 
Deb,

First time I heard Access has a problem with calculations. Now granted it
does not Round the say way Excel does but there are numerous, let me say
that again, NUMEROUS fixes for that. However, I created a Property
Appraisal database which amounts to a big calculator and it calculates just
fine. Now that being said, without knowing what type of database you want
to create we can't tell you if Access is the correct tool for the job.

And let's be nice to the woman in the office, she is probably just a little
out of her comfort zone when it comes to Access and would feel better if the
application was something that she *knew*.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm
 
I can categorically state that Access does not have "a lot of problems with
processing calculations correctly".

Calculations have worked just fine for me in Access, in every version that
I've used from Access v. 1.0 through the current Access 2007. Nor have I
heard of any problems with calculations from beta testers of Access 2010.

Some individuals have had problems of various kinds with Access, but as you
know if you follow this newsgroup, that almost always it is the individual
who has the problem, not Access.

There is no groundswell of companies "dumping Access because it doesn't
process calculations correctly". Does she say just what database it is that
"works better" with which these major companies have allegedly replaced it?
(No? I thought not.)

As far as I know, every (or almost every) enterprise-level company around
the world that uses Microsoft platforms (and that is the vast majority) has
people who use Access.

Larry Linson
Microsoft Office Access MVP
 
is there a general problem with doing calcs in Access?
No.

there is a woman in the office here that is trying to derail the use of
Access for the database and she claims it has a lot of problems with
processing calculations correctly, she's spouting all kinds of heresay that
major companies have dumped it in favour of other programs that apparently
work better
Click to expand...

Access is installed - and used - on more computers than any other database
software.
i'm thinking this is a load of #$#$%
Click to expand...
yes?
Click to expand...

Yes.

If your coworker cares to post some specifics, I'm sure they will be easily
refuted.
 
There are no specific issues with calculations in Access that I am aware of
and I have been developing database applications which have been used by some
very large companies. Please consider that if there were the kinds of issues
that you state that this other person is claiming, this would be of such a
major issue that the product would not have survived and qrown as it has for
years.

There are Access users and developers using this product everyday. Some in
"mom and pop" shops and may otheres in very large corporations. If these
types of claims had any foundation it would certainly be a huge topic of
conversation.

It is evident that she does not have a clue what she is talking about. It
is also plain that she does not know anything about Access.

Mr. B
http://www.askdoctoraccess.com/
Doctor Access Downloads Page:
http://www.askdoctoraccess.com/DownloadPage.htm
 
Sounds like someone has an angenda to promote but not much knowledge about
computers or database applications.
 
is there a general problem with doing calcs in Access?

there is a woman in the office here that is trying to derail the
use of Access for the database and she claims it has a lot of
problems with processing calculations correctly, she's spouting
all kinds of heresay that major companies have dumped it in favour
of other programs that apparently work better

i'm thinking this is a load of #$#$%
Click to expand...

Your thinking is correct.

Have her cite her sources. She won't have any, or the sources she
cite won't be saying what she believes them to be saying.
 
thanks, thats exactly what i wanted to hear and i'll show your response to my
manager.

i think the problem mainly is that she doesnt want to learn Access because
she currently has all the databases in excel and she's happy with that - its
going to take some convincing to get her to change, i'm actually having
trouble with her handing me the existing data to convert to accesss

luckily i have the owner of the business fully in favour of access
 
Access does have some 'quirks' or rules that people new to it might not know
such as math on fields that may have nulls.
Or if you try to add text fields -- [Field1] + [Field2] containing 25 and 57
you will get 2557 as it concatenates the fields.
 
ive already argued that the issue is people not knowing how to use access
rather than access being unstable

she's just an idiot
--
deb


KARL DEWEY said:
Access does have some 'quirks' or rules that people new to it might not know
such as math on fields that may have nulls.
Or if you try to add text fields -- [Field1] + [Field2] containing 25 and 57
you will get 2557 as it concatenates the fields.

--
Build a little, test a little.


deb said:
thanks, thats exactly what i wanted to hear and i'll show your response to my
manager.

i think the problem mainly is that she doesnt want to learn Access because
she currently has all the databases in excel and she's happy with that - its
going to take some convincing to get her to change, i'm actually having
trouble with her handing me the existing data to convert to accesss

luckily i have the owner of the business fully in favour of access
Click to expand...
Click to expand...
 
â€â€ÙƒØªØ¨ "deb said:
thanks, thats exactly what i wanted to hear and i'll show your response to
my
manager.

i think the problem mainly is that she doesnt want to learn Access because
she currently has all the databases in excel and she's happy with that -
its
going to take some convincing to get her to change, i'm actually having
trouble with her handing me the existing data to convert to accesss

luckily i have the owner of the business fully in favour of access
Click to expand...
 
Back
Top