Record Size

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

Everytime I add a record my Database size goes up 20kb is that a lot?
Also a form I had loaded fast, but as I add records it keeps getting
slower, any way to fix this?
Thanks
DS
 
What's included in your "record"?

What thing is "getting slower"?

Do you have indexes set on your tables?

How many tables are you using, joined how?

How slow is "slow"?

How many rows in your table(s)?

What kind of environment (PC, LAN, split database, ...)?

Without specific descriptions, suggestions are guesses.

Regards

Jeff Boyce
<Office/Access MVP>
 
Jeff said:
What's included in your "record"?

What thing is "getting slower"?

Do you have indexes set on your tables?

How many tables are you using, joined how?

How slow is "slow"?

How many rows in your table(s)?

What kind of environment (PC, LAN, split database, ...)?

Without specific descriptions, suggestions are guesses.

Regards

Jeff Boyce
<Office/Access MVP>
Click to expand...
I have 11 fields to a record, it's one table, It starts at 1bout .2 Sec
and then slows to 2.5 seconds....11 rows, Its an unsplit database run
on a local machine....still in development. I hope this helps.
Thanks
DS
 
DS said:
I have 11 fields to a record, it's one table, It starts at 1bout .2 Sec
and then slows to 2.5 seconds....11 rows, Its an unsplit database run
on a local machine....still in development. I hope this helps.
Thanks
DS
Click to expand...

Did you try using Tools --> Database Utilities --> Compact and Repair
Database? Eleven records of 11 fields each shouldn't take 2 seconds to
display, but sometimes other things are going on in the background.
(Virus scans, adware, or Internet activity can occupy CPU/disk
attention.) You might try temporarily turning off some Windows services.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
Back
Top