Error after installation: no license rights? "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> 20.07.2006 23:00:29 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

Re: Error after installation: no license rights? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 21.07.2006 00:39:17 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[ at ]2maximizesoftware2.com> wrote in message news:bYednXdrfbCNll3ZnZ2dnUVZ_tidnZ2d[ at ]comcast.com... [Quoted Text] > 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 >

Re: Error after installation: no license rights? "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> 21.07.2006 01:04:09 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[ at ]NOSPAM_canada.com> wrote in message news:ejj4Z4FrGHA.3992[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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[ at ]2maximizesoftware2.com> wrote in message > news:bYednXdrfbCNll3ZnZ2dnUVZ_tidnZ2d[ at ]comcast.com... >> 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 >> > >

Re: Error after installation: no license rights? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 21.07.2006 11:33:57 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[ at ]2maximizesoftware2.com> wrote in message news:ncCdnSnliZ6XtV3ZnZ2dnUVZ_vCdnZ2d[ at ]comcast.com... [Quoted Text] > 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[ at ]NOSPAM_canada.com> wrote in message > news:ejj4Z4FrGHA.3992[ at ]TK2MSFTNGP04.phx.gbl... >> 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[ at ]2maximizesoftware2.com> wrote in message >> news:bYednXdrfbCNll3ZnZ2dnUVZ_tidnZ2d[ at ]comcast.com... >>> 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 >>> >> >> > >

Re: Error after installation: no license rights? "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> 21.07.2006 15:51:10 "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:OoX3NmLrGHA.4236[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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? No, there is no code reference. The text I provided was verbatim. > 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. 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 > -- > Doug Steele, Microsoft Access MVP > http://I.Am/DougSteele > (no private e-mails, please) > > > "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> wrote in message > news:ncCdnSnliZ6XtV3ZnZ2dnUVZ_vCdnZ2d[ at ]comcast.com... >> 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[ at ]NOSPAM_canada.com> wrote in message >> news:ejj4Z4FrGHA.3992[ at ]TK2MSFTNGP04.phx.gbl... >>> 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[ at ]2maximizesoftware2.com> wrote in message >>> news:bYednXdrfbCNll3ZnZ2dnUVZ_tidnZ2d[ at ]comcast.com... >>>> 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 >>>> >>> >>> >> >> > >

Re: Error after installation: no license rights? "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> 21.07.2006 17:42:57 "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message news:OoX3NmLrGHA.4236[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > 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. 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>

Re: Error after installation: no license rights? "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> 21.07.2006 19:49:14 "Larry Hodges" <2larry2[ at ]2maximizesoftware2.com> wrote in message news:KvCdndk3wKm_j1zZnZ2dnUVZ_smdnZ2d[ at ]comcast.com... [Quoted Text] > "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_canada.com> wrote in message > news:OoX3NmLrGHA.4236[ at ]TK2MSFTNGP04.phx.gbl... >> 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. > > 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? 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)