Senin, 31 Oktober 2011

RE: [MS_AccessPros] Database Corruption Problems

 

David-

Please explain what you mean by "click out of programs". Is "programs" another form in the app? Do you have any code running in GotFocus?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of David Tolson
Sent: Tuesday, November 01, 2011 3:00 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Database Corruption Problems

John, the blow-ups are not as frequent, but there does seem to be a pattern here. Access just stops working when I click out of programs and go back to the main menu. It is not a switchboard, but a form that I made to mimic a switchboard. When I get back to frmMenuMaster, Access stops working.

r/David

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Viescas
Sent: Monday, October 31, 2011 2:44 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Database Corruption Problems

David-

Finding and fixing the compile error should have cleaned it up. If you're still having problems, try importing into a new database, do a compile and save, and then compact/repair.

Good luck!

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of David Tolson
Sent: Monday, October 31, 2011 7:32 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Database Corruption Problems

Thank you John, I have tried your suggestions, and although I did have one compile issue, after correcting it, I am still having the problems, and I do not have any Missing references.

Thanks,

David

From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of John Viescas
Sent: Monday, October 31, 2011 10:30 AM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] Database Corruption Problems

David-

Open the VB Editor and choose References from the Tools menu. Do you see any libraries marked "Missing"? If so, that's your problem. If not, then does the project compile? (Debug - Compile) Compile errors can cause those messages.

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> [mailto:MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Jim Wagner
Sent: Monday, October 31, 2011 2:58 PM
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: Re: [MS_AccessPros] Database Corruption Problems

David,

This happens to my boss on several databases we support every time she opens it. But on my computer, I have no issues. We have never figured out why. Have you tried opening the database on another computer?

Jim Wagner
________________________________

________________________________
From: djsdaddy531 <drtolson@verizon.net <mailto:drtolson%40verizon.net> <mailto:drtolson%40verizon.net> >
To: MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals%40yahoogroups.com> <mailto:MS_Access_Professionals%40yahoogroups.com>
Sent: Monday, October 31, 2011 6:49 AM
Subject: [MS_AccessPros] Database Corruption Problems

Great Day, the Access application that I am creating appears to be
corrupted BIG TIME. I am randomly receiving the error message…

The expression On Click you entered as the event property setting
produced the following error: User defined type not defined.

Or sometimes the application just stops working

Now, I have received these errors in the past, and either a Compact and
Repair or creating a new database and transferring all of the objects
would normally correct it. This time neither process has corrected the
problem. I even tried to do some maintenance on my disk and that has not
corrected the problem, and I have also split the database.

Any suggestions on how to remedy this problem will be greatly
appreciated.

Thanks in advance,

David

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar