slow

[NES]

I am working with Access 2000. I have a data base that contains
approximately 5,400 records. Last week the database starting running very
SLOW. When I input data in a query or even just print a record there is a
delay that makes it painfully slow. This has never happened before.

Does anyone have any idea WHY this is happening?

THANK YOU!

 

[Jerry Whittle]

What else changed? Was some other software installed? Have you run a good
virus and spyware checker lately?

One simple check is to temporarily disable your virus checker and see if it
runs faster then.

For a very good discussion of performance problems check out Tony Toews' web
site:
http://www.granite.ab.ca/access/performancefaq.htm

 

[NES]

I hope that I have a way to solve this problem. Every fiscal year I creat a
new database. I would keep the PEOPLE in my database but delete their
information and START over. I looked at the properties and my 2007 database
was 20.2 MB. I copied it the way someone said to and I now have a database
with the information I need and it is 4.58 MB and it works much faster.

My problem now is....I CAN NOT RENAME the database. It is called NEW
MICROSOFT ACCESS APPLICATION. When I go to change it....I get the message
"If you change a filename extention it may become unusable". HELP...please!

 

[nomadk]

Just add ".mdb" to the filename.

I hope that I have a way to solve this problem. Every fiscal year I creat a
new database. I would keep the PEOPLE in my database but delete their
information and START over. I looked at the properties and my 2007 database
was 20.2 MB. I copied it the way someone said to and I now have a database
with the information I need and it is 4.58 MB and it works much faster.

My problem now is....I CAN NOT RENAME the database. It is called NEW
MICROSOFT ACCESS APPLICATION. When I go to change it....I get the message
"If you change a filename extention it may become unusable". HELP...please!

 

[NES]

THANK YOU...you were right....I added the .mdb to it and it saved.

I just want to run this by you. I went back in and copied the
database...using the

create a new database
click on file + get eternal data + import
click on the tab table
select all of the tables
etc. etc. etc.

By doing those steps (instead of the way I use to copy a database...which I
told you was the COPY and then PASTE) the database went from 20 MB to 4MB. I
am thinking since I was doing the CUT and PASTE thing evey years since 2002 I
had all sorts of other "stuff" hidden in the database. Does that make sense
to you?

Again, thank you!

 

[nomadk]

My guess is you could have achieved the same volume reduction by running
Compact and Repair on your original database.

 

[NES]

Is that easy to do?

My guess is you could have achieved the same volume reduction by running
Compact and Repair on your original database.

 

[John W. Vinson]

Every fiscal year I creat a
new database. I would keep the PEOPLE in my database but delete their
information and START over.

So you simply throw away all your corporate history? What will you do if a tax
auditor comes calling?

4.5Mbyte is a TINY database. You're limited to 2048MByte. You can recover lost
space by compacting; you can speed up your queries by proper indexing; you can
speed up other things using the hints at
http://www.granite.ab.ca/access/performancefaq.htm
especially turning off Subdatasheets and Track Name Autocorrect.

Rather than deleting all your data, I'd really suggest keeping it and using
Queries (filtering the data on a properly indexed field) to display this
fiscal year - or any previous fiscal year.

 

[nomadk]

Yes. With your database open, go to Tools/Database Utilities/Compact and
Repair Database...