Access data accuracy issue

[Boon]

Hi,

I have Access database size about 400MB. I have a macro that will run
queries. This macro runs about 2-3 minutes. Lots of calculation, make table,
append, update.

After running this macro, I then have another program that will access the
data in this database. Then I perform analysis in that program. I noticed
that the results of the analysis in that program is not the same everytime
after I ran the macro in Access. I figured out that I have to do the Compact
and Repair in Access everytime after running the Macro, then the result in
the program will be the same everytime. It is like Access is not stable if
not do the Compact and Repair after complex queries running. Is there a
reason why?

Thanks for your explanation.

Boon

 

[Gina Whipp]

Boon,

Sounds like your database is suffering from bloat and perhaps even reaching
it's 2 gig limitations? Perhaps you could streamline your Make Table
(bloat), Update (bloat) and Append (more bloat) queries?

What is the size of your database after running the macro?

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm

 

[Boon]

It is still less than 1 GB.

Boon,

Sounds like your database is suffering from bloat and perhaps even
reaching it's 2 gig limitations? Perhaps you could streamline your Make
Table (bloat), Update (bloat) and Append (more bloat) queries?

What is the size of your database after running the macro?

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm

 

[Gina Whipp]

Boon,

Okay well that shouldn't be the problem. Do you have Autocorrect Name
turned off (or unchecked)? Can you provide a small sample of what the data
should look like and what it does look like that is the problem?

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm