By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,492 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

MS Access Project Explorer showing New Icon and Crashing with Errors

P: n/a
I have been working with for two days on a database with no
problems(changing forms and adding code to the forms and a module).
Shut down last night was fine, with no errors generated.

This morning, I opened the database and I started getting the dialog
"MSACCESS.exe has generated errors and will be closed by Windows. You
will need to restart the program. An error log is being created."
with an OK button. Access shuts down.

If I open the database again, and click on my first form that pops up,
I get the error. If I don't click the form, I can access the Access
menus, however.

If I go to the VBA code, I can view code for all my forms. I can
enter new code (ie comments), but once I enter the built-in function
MsgBox( the error occurs again. I can enter user-made functions
without incident.

I notice that a new icon is in the Project Explorer. It looks like a
form, but clicking it causes an error. The icon looks like the logo
from a printout. It looks like a small sheet of paper with blue
border and blue horizontal lines with the top right corner turned down
and a bit of light blue on the top right corner.

This icon is different from the form icons, and it located right under
the form icons but before the Modules. I have a form named
Form_frmPricingReport. This new icon has the name frmPricingReport.
Obviously, they are somehow connected, but I don't know how.

I have tried to compact and repair the database several times with no
change. I have tried to use the /decompile hack, to no avail (when I
run this through a batch program, the database starts and immediately
gives me the error message above.)

Also, when I attempt Debug > Compile in VBA I get the error.

Any ideas as to what the new icon is and how to rescue the database?

Thanks,
Gordon Sanderson
go******@texas.net
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Please disregard the following message. If anyone knows what that
symbol means in front of my form, I'd like to know, however. I did not
find the answer to repairing the database, but I copied the updated
forms and code to a backup copy of the database. The new database and
forms are working fine now.

Thanks,
Gordon Sanderson
go******@texas.net (Gordon Sanderson) wrote in message news:<52**************************@posting.google. com>...
I have been working with for two days on a database with no
problems(changing forms and adding code to the forms and a module).
Shut down last night was fine, with no errors generated.

This morning, I opened the database and I started getting the dialog
"MSACCESS.exe has generated errors and will be closed by Windows. You
will need to restart the program. An error log is being created."
with an OK button. Access shuts down.

If I open the database again, and click on my first form that pops up,
I get the error. If I don't click the form, I can access the Access
menus, however.

If I go to the VBA code, I can view code for all my forms. I can
enter new code (ie comments), but once I enter the built-in function
MsgBox( the error occurs again. I can enter user-made functions
without incident.

I notice that a new icon is in the Project Explorer. It looks like a
form, but clicking it causes an error. The icon looks like the logo
from a printout. It looks like a small sheet of paper with blue
border and blue horizontal lines with the top right corner turned down
and a bit of light blue on the top right corner.

This icon is different from the form icons, and it located right under
the form icons but before the Modules. I have a form named
Form_frmPricingReport. This new icon has the name frmPricingReport.
Obviously, they are somehow connected, but I don't know how.

I have tried to compact and repair the database several times with no
change. I have tried to use the /decompile hack, to no avail (when I
run this through a batch program, the database starts and immediately
gives me the error message above.)

Also, when I attempt Debug > Compile in VBA I get the error.

Any ideas as to what the new icon is and how to rescue the database?

Thanks,
Gordon Sanderson
go******@texas.net

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.