Access DLL Error/VBA Error

[Tom]

I am having a hudge issue with Access 2007 that is preventing me from
programing in VBA and am REALLY hoping someone can help.

There are at least two issues. If I add a control and the control wizard is
selected, I get the "Error in Loading DLL" error and cannot use the wizard.
Also, if I open VBA, and type "me." into the module, as soon as I type the
period, Access and VBA crashes. I have deselected the references
to Microsoft Office 12.0 Access dataase engine Object and OLE Automation
(the only two I could de-select) but still get the same error. I uninstalled
Office and re-installed, re-registered most DLL's, reinstalled MDAC, and
still cannot get this thing to work. I am running Win 7 (64 bit) with Office
Enterprise 2007. Any ideas PLEASE on what else to try???

 

[Gina Whipp]

Tom,

Sounds like your VBA module somehow became corrupt. I would try creating a
new database, make sue Name Autocorrect is turned of and import all your
objects into it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am having a hudge issue with Access 2007 that is preventing me from
programing in VBA and am REALLY hoping someone can help.

There are at least two issues. If I add a control and the control wizard is
selected, I get the "Error in Loading DLL" error and cannot use the wizard.
Also, if I open VBA, and type "me." into the module, as soon as I type the
period, Access and VBA crashes. I have deselected the references
to Microsoft Office 12.0 Access dataase engine Object and OLE Automation
(the only two I could de-select) but still get the same error. I uninstalled
Office and re-installed, re-registered most DLL's, reinstalled MDAC, and
still cannot get this thing to work. I am running Win 7 (64 bit) with Office
Enterprise 2007. Any ideas PLEASE on what else to try???

 

[joelgeraldine]

y jh ;j,j

 

[Gina Whipp]

Tom,

Is your database in a Trusted Location?

http://www.regina-whipp.com/index_files/TrustedLocation.htm

--
Gina Whipp
2010 Microsoft MVP (Access)

http://www.regina-whipp.com/index_files/TipList.htm


I am having a hudge issue with Access 2007 that is preventing me from

programing in VBA and am REALLY hoping someone can help.

There are at least two issues. If I add a control and the control wizard is
selected, I get the "Error in Loading DLL" error and cannot use the wizard.
Also, if I open VBA, and type "me." into the module, as soon as I type the
period, Access and VBA crashes. I have deselected the references
to Microsoft Office 12.0 Access dataase engine Object and OLE Automation
(the only two I could de-select) but still get the same error. I uninstalled
Office and re-installed, re-registered most DLL's, reinstalled MDAC, and
still cannot get this thing to work. I am running Win 7 (64 bit) with Office
Enterprise 2007. Any ideas PLEASE on what else to try???

I have the same problem. I run Office pro plus 2007 on win 7 (64).
I uninst. reinst. , made a new test db but the problem remains.
I too need help.

 

[David Kaye]

Is your database in a Trusted Location?

We had a problem with a database in an office where it seemed to go down some
nights. Couldn't figure it out. Turned out the janitor unplugged the
computer, thinking it was off, plugged in his vacuum cleaner, then plugged the
computer back in again. This particular model did auto-start, but for some
reason it couldn't connect to the network on the fly, so it had to be reset 3
days a week.

We moved the computer to a locked closet.

 

[Gina Whipp]

David,

Now that is a funny story... probably, not at the time but that is
priceless. Let's hope that's not what happening to the OP!

--
Gina Whipp
2010 Microsoft MVP (Access)

http://www.regina-whipp.com/index_files/TipList.htm

Is your database in a Trusted Location?

We had a problem with a database in an office where it seemed to go down
some
nights. Couldn't figure it out. Turned out the janitor unplugged the
computer, thinking it was off, plugged in his vacuum cleaner, then plugged
the
computer back in again. This particular model did auto-start, but for some
reason it couldn't connect to the network on the fly, so it had to be reset
3
days a week.

We moved the computer to a locked closet.

 

[brien1951]

Nobody has mentioned this so I ask here as this is what my problem turned out to be. If you have upgraded from office XP to office 2007

When you bring up Access, go to Database tools, then click on Visual Basic - this will open up a visual basic codel, Select Tools/references... see if you have a "checked" box for "Missing: Microsoft Office XP Web Components" if so, uncheck it, close your database and reopen it. Once I "unchecked" it - it went away. Basicly when 2007 was install some of the XP DLL's or active X libaries no longer work and causing broken DLL messages, preventing forms from opening and other errors.

NOTE: I uninstalled and reinstall Access on my PC as well but the problem still existed untiled I checked the Visual Basic settings.

Information came from this thread:
https://www.pcreview.co.uk/forums/thread-1700057.php