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]
Tidak ada komentar:
Posting Komentar