Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Access immediately re-launches after close

Posted on 2012-09-20
6
Medium Priority
?
268 Views
Last Modified: 2012-09-27
I have an MS Access application used by 10 people on our network. Just 1 of these machines has a problem that when I close the application, I see the desktop briefly then a second later MS Access immediately re-launches into a blank window. I can open other databases subsequently, but Access will re open every time I close it.

I can close it using Task Manager. It then reopens and can be closed normally
0
Comment
Question by:TownTalk
  • 3
  • 3
6 Comments
 
LVL 85
ID: 38419933
So you mean that ACCESS opens, or that a Database opens (that is, Access opens and then a Database opens)?

Have you insured that the machine is fully up to date in regard to service packs, for both Office/Access and Windows? Given that it's just one machine, I would think a faulty or corrupt install would be a likely culprit.
0
 

Author Comment

by:TownTalk
ID: 38424238
No a database doesn't open. I just get a blank screen where I can subsequently open a database. But any attempt to close Access  causes it to reopen again to a blank screen.

Windows is up to date. Not sure about Access though. I'm not in the office until Thursday, i'll check it out then.
0
 
LVL 85
ID: 38424458
Also might check to insure that your user profile is okay - log into the machine as a different user and see if the issue continues. If it works fine with the other login, then you may have a corrupt user profile.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 

Author Comment

by:TownTalk
ID: 38440160
I uninstalled Access and reinstalled. The problem still persisted. I logged on as a different User and didn't see the problem. So the problem must be related to the profile. I would prefer not to delete the profile and re-create it. Is there anything I can do to fix the profile?
0
 
LVL 85

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 38440211
I don't know of any method to recover a corrupted profile. You can copy the settings and such to a new profile, however:

http://support.microsoft.com/kb/811151
0
 

Author Closing Comment

by:TownTalk
ID: 38440424
OK. Thank you for your help. I never would have suspected the user profile. Strange though, it only happens with this one database, and if I make a .ACCDE from that database, I can open  and close it without seeing this issue.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question