Erwin Craps
Erwin.Craps at ithelps.be
Sat Jun 28 05:47:44 CDT 2003
Hi Some "fast out of the fist" tips... 1) You can install the runtime without an app. Download the limited runtime from MS. (smaller package without IE5). 2) You can run MDE and MDB. 3) Multiple things to watch out for. a) You need a user interface (menu). b) Lot of basic functionality is not available, most buttons are not present in runtime like filter, sort etc. c) you need error trapping in EVERY function/sub routine. Every error that is not covered by a error trapping results in Access terminating (crash). d) You will get reference problems. If you notice that basic funtions like date() are not working you have a broken refenrence. For example your app was build with a reference to word 10 and the client pc has word 9. solve it to reference by default to word 9. if you have word 10, it still works. e) I had problems with rowsource properties. For example if you have a listbox for which you change the rowsource (sqlstring) dynamicly from code. If you leave the properties (when saving the form) empty then your listbow will not work. A valid rowsource needs to be present on listboxes, etc.. f) watch out for controls. If you use controls like the calender control you need to install/register those to. This can be easely solved by using the package wizard in the developer kit. And a good advice. First try on one (not already contaminated) pc. I mean a pc that has no development software etc. A pc that represants the biggest part of your computerpark. Test all special stuff like word/outlook/excel connections etc. Watch out for calculated errors /date function not working. Take a look at all forms/reports where you use controls (like calendar control, gauge bars etc..). Hope this helps. Erwin -----Oorspronkelijk bericht----- Van: Lembit.Soobik at t-online.de [mailto:Lembit.Soobik at t-online.de] Verzonden: zaterdag 28 juni 2003 9:58 Aan: accessd at databaseadvisors.com Onderwerp: Re: [AccessD] Access Run Time? This is my test - sending the answer which did not get through and made me aware that something was wrong with the list. Alun, the runtime is installed with the application, not as separate thing when you have developed an Access Application, you convert the MDB to an MDE then you set up an installation package which will install everything you need to run the mde without an installed full Access software. to do this, you need to have the Developer edition of Access (or Office) If youo have this developer ecition, then you may sell/install as many Access Applications on machines without preinstalled Access or Office as you like.. you can run an MDB or an MDE on any machine that has full Access installed, however on machines which dont have full Access, you need to build the install package and install your application. this will not let you run just any MDB. Just the ones you install withthe runtime One thing I am presently not sure about (since it is many many years ago that I did this) is whether you need to convert to MDE or can use MDB as well with the runtime installation. During development you can test how your application behaves with runtime, I think you use /runtime in the commandline my experienc on all of this is with Access97 and prior. not using it now. I am sure there will some other listers correct me where I was wrong or add about newer versions Lembit Lembit Soobik ----- Original Message ----- From: "Garraway, Alun" <Alun.Garraway at otto.de> To: "Access DatabaseAdvisors (E-Mail)" <accessd at databaseadvisors.com> Sent: Friday, June 27, 2003 12:38 PM Subject: [AccessD] Access Run Time? > Hallo, > the network bods are talking about installing the Access Run Time for > "Normal" users, I have a few questions, about this & its implications > for me. > > 1. does the run time have to be installed on every maschine in an > NT-Network? > > 2. can all users open .MDBs without any problems when the run time is > installed? > (are there anythings that maybe won't work?) > > 3. are there anythings I have to watchout for when programing an mdb > used in the > run time envirnment? (for ex. can an error in code cause a crash?) > > TIA for any tips > alun > > > Alun Garraway > IM-IT Sonderprojekte LBB-D1 > Tel. (040) 64 61 5573 > Fax (040) 64 64 5573 > mailto:alun.garraway at otto.de > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com