Previous Thread

7/20/2006 4:00:29 PM    Error after installation: no license rights?
I'm newly upgraded from XP Dev, so forgive my ignorance at this point... 
 
Running Access 2003 
 
Packaged with Visual Studio 2005 Tools for MS Office 
 
I've created an installation package using an MDE file and Access 2003 
 
runtime.  Installation goes fine without any errors.  However, when running 
 
the application I get a msg box with the following text: 
 
----------- 
 
The expression On Open you entered as the event property setting produced 
 
the following error: License Information for this component not found.  You 
 
do not have an appropriate license to use this functionality in the design 
 
environment. 
 
* The expression may not result in the name of a macro, the name of a 
 
user-defined function, or [Event Procedure]. 
 
* There may have been an error evaluating the function, event, or marco. 
 
----------- 
 
It sounds like it's trying to run the full version of Access, not the 
 
runtime.  The client box does not have retail Access.  Any help would be 
 
appreciated. 
 
Larry Hodges 
 
Maximize Software



7/20/2006 6:04:09 PM    Re: Error after installation: no license rights?
Hi Doug, thanks for the reply. 
 
This is an application I have deployed successfully in Access2002 and 
 
distributed using the package and deployment wizard included with the Access 
 
2002 Dev. Edition. 
 
Yes, it runs fine on the development machine, including the MDE running with 
 
[ /runtime].  And I have no macros...everything is VBA. 
 
I've run the debugger and compiled the code in Access 2003, so there is no 
 
missing references.  I have code in the splash screen form that checks for 
 
links to the backend.  If it's not there, then opens a form to browse to the 
 
location and refresh the links. 
 
Any input would be greatly appreciated.  I'm due to deliver this tomorrow. 
 
Not that it matters, but the development box is running x64.  I noticed that 
 
the versions of the Visual Studio 2005 installed were 64 bit versions. 
 
Pretty cool that it's coded for 64 bit. 
 
And of course, everything is patched current according to Microsoft Update. 
 
Which should go without saying...but you just never know with some people... 
 
-Larry 
 
Maximize Software, Inc. 
 
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
 
news:ejj4Z4FrGHA.3992@TK2MSFTNGP04.phx.gbl...

7/20/2006 8:39:17 PM    Re: Error after installation: no license rights?
Can you identify the line of code it's failing on, and post it here? 
 
It sounds as though you're trying to do something that requires that the 
 
form be in Design mode. You can't do that using the runtime. Does the MDE 
 
run properly with the full version of Access? 
 
-- 
 
Doug Steele, Microsoft Access MVP 
 
http://I.Am/DougSteele 
 
(no private e-mails, please) 
 
"Larry Hodges" <2larry2@2maximizesoftware2.com> wrote in message 
 
news:bYednXdrfbCNll3ZnZ2dnUVZ_tidnZ2d@comcast.com...

7/21/2006 7:33:57 AM    Re: Error after installation: no license rights?
You give a lot of information there, but you haven't answered my question! 
 
Can you identify the line of code it's failing on? 
 
Not quite sure what your "compiled the code in Access 2003, so there is no 
 
missing references." is implying: you do realize, I hope, that just because 
 
the references are fine for a given database on machine A doesn't mean 
 
they'll be fine on machine B. 
 
-- 
 
Doug Steele, Microsoft Access MVP 
 
http://I.Am/DougSteele 
 
(no private e-mails, please) 
 
"Larry Hodges" <2larry2@2maximizesoftware2.com> wrote in message 
 
news:ncCdnSnliZ6XtV3ZnZ2dnUVZ_vCdnZ2d@comcast.com...

7/21/2006 8:51:10 AM    Re: Error after installation: no license rights?
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
 
news:OoX3NmLrGHA.4236@TK2MSFTNGP04.phx.gbl... 
 
No, there is no code reference.  The text I provided was verbatim. 
 
Prior to creating the MDE, open the code window.  On the toolbar, select 
 
Debug > Compile.  This compiles the VBA code and will tell you if you have 
 
any missing references, which is quite possible when upgrading to a new 
 
version of Access.  For example, you may have some ADO code in your project 
 
but be missing the ADO Reference. 
 
Hey, I thought you were the MVP?  :p 
 
-Larry

7/21/2006 10:42:57 AM    Re: Error after installation: no license rights?
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message 
 
news:OoX3NmLrGHA.4236@TK2MSFTNGP04.phx.gbl... 
 
It was my understanding that the Package and Deployment wizard would analyze 
 
those dependencies and include them with the installation?  Calendar Control 
 
for example.  Is that not the case anymore with VS2005 tools? 
 
-Larry 
 
<snip>

7/21/2006 3:49:14 PM    Re: Error after installation: no license rights?
"Larry Hodges" <2larry2@2maximizesoftware2.com> wrote in message 
 
news:KvCdndk3wKm_j1zZnZ2dnUVZ_smdnZ2d@comcast.com... 
 
It wasn't really the case with any version. Yes, if the required DLL or OCX 
 
was missing, it should provide it. However, if it already exists but isn't 
 
the same version, there can be problems. As well, your users can certainly 
 
install other software after installing your application, which can cause 
 
your application to break. 
 
As to my suggestion as to identifying the line of code that's failing, if 
 
your error trapping isn't giving you details of where in the code you are, 
 
you might have to provide a customized version of the application that does 
 
indicate line number. 
 
-- 
 
Doug Steele, Microsoft Access MVP 
 
http://I.Am/DougSteele 
 
(no private e-mails, please)