Why does my mdb take so long to open? 5

[steve728]

Where can I start checking within my large (145MB)mdb file to find out why it takes so long to open. Even when I hold down the Shift key to open it in programmer's mode.
Should I look at the general modules for excessive global memvars, etc. Any other ideas would greatly help! Maybe some setting in the general config.???

Steve728

 

[StrikeEagleII]

Have you tried compacting it? Within Access, go to Tools > Database Utilities > Compact and Repair Database...
It'll clean itself up and make the mdb much smaller (especially if you've been working on it a lot).
If you go into Tools > Options, you can check "Compact on Close" so the database cleans itself up everytime it's closed.

Hope that helps,
Jason

 

[steve728]

I frequently compact the mdb. That's not the problem.

 

[dhookom]

Are you running an anti-virus program? Is the MDB on a server or local machine?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[steve728]

Excellent questions! I'm running AVG Free and on a local PC. The application is not on the network. WinXP, 768RAM,
1.5 GZ processor and plenty of hardisk space.

 

[dhookom]

I also run AVG and don't seem to have similar problems. Have you check the Task Manager->Performance and/or Processes to see what might be happening?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Ed2020]

Following on from Duane's last post:

I'd try Process Explorer and Process Monitor (both freeware apps from

http://www.sysinternals.com)

- one of these may well give you an insight into what is causing the delay.

Is the delay with just one MDB, or all MDBs on this machine?

Ed Metcalfe.

Please do not feed the trolls.....

 

[jadams0173]

This may be of interest depending on your access version. It has helped my mdb's open faster.
thread702-206410

I tried to have patience but it took to long! -DW

 

[jimlee]

Thanks for that link jadams0173, i've seen that thread before but forgot all about it. Awesome tip which works brilliantly.

jimlad

"There's this thing called being so open-minded your brains drop out." - Richard Dawkins

 

[tarena]

Does anyone know if the following code would work on Access 97?

Private Sub Form_Open(Cancel As Integer)

Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Log Name AutoCorrect Changes", False
Application.SetOption "Perform Name AutoCorrect", False
Application.SetOption "Track Name AutoCorrect Info", False

End Sub

 

[Ed2020]

Tarena,

You will probably get more responses if you start this question in a new thread.

I don't believe any of those options exist under Access 97, so would not only not work but be unnecessary. Unfortunately I do not have Access 97 anymore so I am unable to verify this.

Ed Metcalfe.

Please do not feed the trolls.....

 

[StrikeEagleII]

steve728--
I just read in a book that the table subdatasheet property being set to [Auto] can really slow a database down--see

http://support.microsoft.com/kb/275085.

To change it open a table in design view and in the properties, change Subdatasheet Name to [None] or microsoft has some code that can change all your tables for you.

Haven't tried it out myself yet, but will soon.

Jason