[AccessD] Error 51 in 2010

Shamil Salakhetdinov shamil at smsconsulting.spb.ru
Wed Feb 17 00:10:37 CST 2010


Yes, Rocky, you'd better use late binding when Automating Outlook and Excel
from within your application.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Wednesday, February 17, 2010 12:52 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 51 in 2010

Good idea, Shamil.  I'm wondering now if, since they are apparently using
A2K10 (from the looks of the screen shot they sent), it might not be
resolving the Outlook 11.0 or Excel 11.0 Object Library references set in my
app.

R

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Shamil
Salakhetdinov
Sent: Tuesday, February 16, 2010 1:24 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 51 in 2010

Afterthought: Rocky, your customer probably uses runtime therefore
Access.PowerTools will not be helpful there - please disregard my below
proposal.

AFAIKR if you make a sample mdb with just one start-up form, which will usa
VBA code behind to list references using application.references collection,
set all the same references to this app mdb as your main app has, then
compile it to .mde and send to run on customer site then it will list
references marking broken ones (this marking of the broken ones will be made
by your code - just handle runtime errors using resume next and analyzing
err.number after VBA code line execution - then present the list of form's
multiline textbox or in a message box)...

...if the above will not work then you can make an Automation sample mdb to
run on customer site to list references of automated small mde having all
the same references your main app has (sorry didn't use MS Access runtime
for quite some time - I expect it allows to use Automation...)

Thank you.

--
Shamil 



-----Original Message-----
From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru]
Sent: Wednesday, February 17, 2010 12:04 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Error 51 in 2010

Hi Rocky --

If you're interested to try I can add (for starters) a new feature to
Access.PowerTools to list references of the currently opened mdb/mde marking
which ones are broken. I can release that "References Lister" plug-in
tomorrow with new Access.PoweTools setup just to demonstrate how it can be
done. You can use it there, and you can point to this tool to your customer
in Bahrain for them to check references of your app .mde on their system
(but they will have to have .NET Framework SP1 installed to run the tool. It
will be installed during add-in setup, it takes a few minutes but usually
runs without any issues.)...

...and when v.0.0.3 of Access.PowerTools will be released such a "References
Lister" plug-in will be possible to get developed by everybody: if I have
had v.0.0.3 currently released I could have made and released "References
Lister" plug-in in minutes - I can't do that now that quick as it still need
to deploy all the add-in executables, and I have to go to bed now as it's
12:00 AM (17FEB10) here...

Thank you.

--
Shamil

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, February 16, 2010 11:37 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Error 51 in 2010

The app is an mde - a package that I sell - and the user is not here -
actually in Bahrain.  But I'm going to put it on a test be I've got here  -
W7 r.c. (got noticed today by MS that it will be going away soon so I'd
BETTER UPGRADE NOW!) AND Office 2010 pro r.c. We'll see.  Since the version
of this app has been in use in a lot of places including this user site, I
think it must be something to do with O2K10.

I don't have a reference checker.  Do you know of one an one of those Access
sites somewhere I could crib?

TIA

Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kenneth Ismert
Sent: Tuesday, February 16, 2010 9:22 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Error 51 in 2010

>
> Rocky Smolin:
> I have an error report from an mde compiled in A2K3 but the client 
> appears to be running it with Access 2010.  The error is 'Error 561 - 
> Internal Error'.  Can't find out anything about this error.  The 
> version of the mde they're running is a few minor releases back and is 
> solid.  So I'm thinking this is a 2010 related problem.  Any clues?
>

Check your VBA project references. This sounds exactly like the error I got
when added a cdosys.dll reference to send email over SMTP.

If you have a reference checker built-in to your code, run it and it may
show the broken reference. Otherwise, plunk a development mdb on the
machine, and see if any references are missing/broken.

-Ken
--

 

 

__________ Information from ESET NOD32 Antivirus, version of virus signature
database 4872 (20100216) __________

The message was checked by ESET NOD32 Antivirus.

http://www.esetnod32.ru
 




More information about the AccessD mailing list