Access Database stuck when I open it and try to close it.

[Abeetan]

Hello,

I have been stuck on this issue for the past couple of weeks. I have tried everything to resolve the problem I don't know what more I could do to tackle exactly what is causing the problem. This post is a follow-up to a post I made a few weeks ago. I have removed all the sensitive data and uploaded the database here.

Please let me know what do you think is causing this issue. The database is not split, I removed all security restrictions that I had, I even started a new database and imported the tables, forms, and queries. This appears to happen when i open the database and open the forms, the forms are causing the database to remain open and stuck as seen in the image above. To access the database again I have to go to task manager and end task for MS Access then I can open the database again. This keeps happening.

 

[theDBguy]

Hi. Can't download your file at the moment. Are you automating Access at all? For example, are you using something like OpenDatabase or OpenCurrentDatabase?

Sent from phone...

 

[arnelgp]

i don't see any problem with it.

 

[Abeetan]

Hi. Can't download your file at the moment. Are you automating Access at all? For example, are you using something like OpenDatabase or OpenCurrentDatabase?

Sent from phone...

Not at all. Just plain old Access

 

[Abeetan]

i don't see any problem with it.

I even tried running it on my other PC. it ran without any problems. What do you think the issue is then?

 

[arnelgp]

which version did you run?
the one i uploaded is the "repaired" version (by Stellar Access Repair V.7)

 

[Abeetan]

which version did you run?
the one i uploaded is the "repaired" version (by Stellar Access Repair V.7)

The same file. I didn't change a thing. I just transferred it via usb and ran it on my other PC.

 

[Gasman]

Hello,

I have been stuck on this issue for the past couple of weeks. I have tried everything to resolve the problem I don't know what more I could do to tackle exactly what is causing the problem. This post is a follow-up to a post I made a few weeks ago. I have removed all the sensitive data and uploaded the database here.

View attachment 97720

Please let me know what do you think is causing this issue. The database is not split, I removed all security restrictions that I had, I even started a new database and imported the tables, forms, and queries. This appears to happen when i open the database and open the forms, the forms are causing the database to remain open and stuck as seen in the image above. To access the database again I have to go to task manager and end task for MS Access then I can open the database again. This keeps happening.

I can open it no problem, and I'm on 2007
However your pic is of a BE not a non split DB?

 

[Abeetan]

I can open it no problem, and I'm on 2007
However your pic is of a BE not a non split DB?

Yes, the database was split before so I thought the issue was because of that then I put it back together only to find out that the issue persists.

 

[Gasman]

Well you appear to have eliminated that as an issue?
Try a repair of Office?

 

[oleronesoftwares]

The same file. I didn't change a thing. I just transferred it via usb and ran it on my other PC.

@arnelgp is pointing you to try the file he uploaded since he has repaired it. If the issue still persists you can let us know.

 

[Abeetan]

Hello Everyone!

I finally think I have found the problem here!

This post refers to my issue

MS Access not closing

Hello When I close MS Access which was running a database system I created, I have noticed that on occassion it doesn't close entirely. The MS Access window disappears from the screen but the process still remains in the background. I can see the process in the Task Manager window. I...

www.access-programmers.co.uk

Apparently, when I hit the "x" close button I think that access is closed but in fact, it's running in the background which causes the "Freezing" or "stuck" mode because access is open so when I double click to open it nothing happens.

How can I solve this issue?

 

[Gasman]

So does anything in that thread apply to you?

 

[Abeetan]

So does anything in that thread apply to you?

I am facing the same problem but the solutions presented do not apply to me. Apparently, I may have to introduce some sort of VBA code to make sure all the pop-up forms, and other forms are closed when I click the close button.

 

[oleronesoftwares]

Try application.docmd.closedatabase or read up quit command.

 

[Abeetan]

Try application.docmd.closedatabase or read up quit command.

Where can I add this?

 

[oleronesoftwares]

To the on click event of a form

 

[Abeetan]

I just discovered that it's happening to all my access files on my PC. Do you think it's a setting I can change in my options menu?

 

[oleronesoftwares]

You might need to compact and repair ms access

 

[Abeetan]

Can I just uninstall it and reinstall it again?
would my files be deleted?