Slow on Close (1 Viewer)

M

MickCun1

Registered User.

Local time

Today, 01:27

Joined

May 21, 2018

Messages

31

• Jul 2, 2018

• #1

Hi guys,

I have an access db that once I click close it takes a good 5-10 seconds before it really closes off. The Compact and repair box in options is not checked, I had some vba code for compact and repair that I initially included in the beginning, but I have since removed it and it is still taking a good while to close.

Does anyone have any ideas on how to speed up the closing process?

Regards,
Michael

 

Ranman256

Well-known member

Local time

Today, 01:27

Joined

Apr 9, 2015

Messages

4,337

• Jul 2, 2018

• #2

Did u run compact/repair manually?
Is there code in the UNLOAD event?

 

M

MickCun1

Registered User.

Local time

Today, 01:27

Joined

May 21, 2018

Messages

31

• Jul 3, 2018

• #3

Hi Ranman,

Yes compact and repair was run manually but now I want to remove it to close the database quickly.

There is no code in the unload event form the db.

What do you think the issue could be?

Regards,
Michael

 

P

Pat Hartman

Super Moderator

Staff member

Local time

Today, 01:27

Joined

Feb 19, 2002

Messages

43,263

• Jul 4, 2018

• #4

The db does not have an unload event. The Unload event occurs for every form.