Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 19th, 2005, 07:49 AM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default -2147024770 VBA Office 2003

Needless to point that all Microsoft & Symantec material on the subject is out of date. Office 2003 needs an Online registration procedure.

The call is CreateObject("application.whatever")Err.Descriptio n "Automation Error" & Err.Number"-2147024770 xxxx". Uninstall & reinstall is not a way of solving/understanding problems.

Please relate to the specific problem.

José Maria

Reply With Quote
  #2 (permalink)  
Old March 21st, 2005, 05:37 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Maybe I wasn't too specific.
The problem referred above is well documented concerning previous versions of both Symantec Norton A-V and Microsoft Office.
The thing is to recover the dynamic library that corrupts, which could be the case, if it is the case.


Reply With Quote
  #3 (permalink)  
Old March 22nd, 2005, 09:02 AM
Friend of Wrox
Points: 3,947, Level: 26
Points: 3,947, Level: 26 Points: 3,947, Level: 26 Points: 3,947, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,150
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

You still have not asked the group a question. What is your question? What is the problem and what do you want solved? All you've done so far is tell us how something is supposed to function.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #4 (permalink)  
Old March 22nd, 2005, 10:06 AM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
quote:Originally posted by SerranoG
 You still have not asked the group a question.  What is your question?  What is the problem and what do you want solved?  All you've done so far is tell us how something is supposed to function.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Thank you.

Application.CreateObject is a common line using Office VBEditor.
(Automation, previously JetEngine)

The err.Num is not very common. Yet, information about this specific err.Description and err.Num has been published both by Microsoft and Symantec (aparently occurs when S.Norton A-V is installed over any Office group of programs).

DLL corruption (oleaut32.dll or others)may be the origin of the err.Ocurrence.

In the end it happens that MS & SYM. information does not result in later versions of both products, and one will have to re-install the two packages.

Making it short, I would like to know if any person in the group, having gone through the same problem, would be willing to share the solution for this error in aproximate conditions, i.e., Office 2003.

Thank you again


Reply With Quote
  #5 (permalink)  
Old March 24th, 2005, 12:59 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I hope Microsoft & Symantec Monsieurs & Madames read following lines.

first:
http://support.microsoft.com/kb/246018
and then:
http://support.microsoft.com/kb/244264/EN-US/

or the other way round.
What all those lines mean is "we don't know".
Removing with regsvr /u a .dll can be an encounter with an endless loop of the same err.message.
Removing oleaut32.dll will certainly result in re-install all.

If this happens to any of you, do not remove oleaut32.dll, just rename it.

Automation, previously Jet Engine is a great way of exchanging data. But if it fails at this level it can cause damage, serious damage.

I certainly need help!!

Reply With Quote
  #6 (permalink)  
Old March 28th, 2005, 04:51 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I wish I did have a solution for this problem.

I had to un-install Office 2003, un-install Norton Internet Security 2005 and re-install the two packages in the following order:

Norton Internet Security

Office 2003

I hated it, but it was the only way to have Automation working.

End of story.

Reply With Quote
  #7 (permalink)  
Old March 28th, 2005, 05:12 PM
Friend of Wrox
Points: 3,947, Level: 26
Points: 3,947, Level: 26 Points: 3,947, Level: 26 Points: 3,947, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,150
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

I have found that when I get an error number of a very large negative number, it USUALLY means that I have misspelled something in my call or used a variable for something that doesn't exist. Instead of giving me that exact error message, Access will flash this weird error number instead.

Look closely at your code and make sure every variable is spelled correctly and that every object exists.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
  #8 (permalink)  
Old March 28th, 2005, 07:46 PM
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Greg, the number is negative because its highest bit is set. The error message in this particular case is

    11111111111111111111111111111111100000000000011100 00000001111110

Separated into bytes, that is

    11111111 11111111 11111111 11111111 10000000 00000111 00000000 01111110

(It is an 8-byte number.)

Large errors are not all that uncommon. In fact, MS recommends that when you are creating custom error (to return from classes, UserDefined Functions, etc, that you use vbObjectError + <your own number, 1, 2, 3, etc.>, like Err.Raise vbObjectError + 1, . . .
vbObjectError equals

    -2147221504
    11111111111111111111111111111111100000000000010000 00000000000000
   (Actually the value is 18446744071562330112, when read as an unsigned integer).

So any error you create according to MS’s standards/recommendations will read as a negative number.

Brian
Reply With Quote
  #9 (permalink)  
Old March 29th, 2005, 08:47 AM
Friend of Wrox
Points: 3,947, Level: 26
Points: 3,947, Level: 26 Points: 3,947, Level: 26 Points: 3,947, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,150
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:Originally posted by BrianWren
 Greg, the number is negative because its highest bit is set.  The error message in this particular case is...
 Thanks for the education in error codes. I knew they meant something, but had no clue what!

Error codes such as this don't make much bit of sense to the "average" user and if you press the HELP button upon getting the error, I (for one) always get a blank screen. So without any info from Access, I have figured out that when I get this kind of error, it usually means I mispelled something.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2003 absolute minimum w/VSTO? cjkoontz Visual Studio 2005 0 October 16th, 2008 11:36 AM
Customizing MS OFFICE 2003 using SINGLE DLL..? pradpb999 Access 1 December 27th, 2005 12:37 PM
Customizing MS OFFICE 2003 using windows API's..? pradpb999 General .NET 0 December 27th, 2005 01:15 AM
Customizing MS OFFICE 2003 using C#.NET pradpb999 General .NET 0 December 27th, 2005 01:11 AM
Help me please aboutVS 2003 and Office 2003 Nashja C# 2 May 19th, 2005 12:58 AM



All times are GMT -4. The time now is 11:02 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.