Sharing MAcros/Templates Zoltar54 20.02.2006 15:42:29 I have created a VBA program and will now be sending it to a few users. My question is this - Will all of the references to the Jet and DAO db still work on the new users PC or do they need to set them manually?

Re: Sharing MAcros/Templates "Doug Robbins - Word MVP" <dkr[ at ]REMOVETHISmvps.org> 20.02.2006 16:28:21 See the article "Distributing macros to other users" at: http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm If you are sending them the Template in which you have the references set, they shoud be maintained. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Zoltar54" <Zoltar54[ at ]discussions.microsoft.com> wrote in message news:C21139BE-D60F-46C9-A413-977F50CE6806[ at ]microsoft.com... [Quoted Text] >I have created a VBA program and will now be sending it to a few users. My > question is this - Will all of the references to the Jet and DAO db still > work on the new users PC or do they need to set them manually?

Re: Sharing MAcros/Templates "Jezebel" <warcrimes[ at ]whitehouse.gov> 21.02.2006 04:28:48 There's no guarantee that JET/DAO will be available on a new PC. Usually it is (if only because there's still a lot of legacy software around that uses it); but I've seen at least one corporate configuration of new XP machines that didn't include it. "Doug Robbins - Word MVP" <dkr[ at ]REMOVETHISmvps.org> wrote in message news:%23jiZsqjNGHA.2916[ at ]tk2msftngp13.phx.gbl... [Quoted Text] > See the article "Distributing macros to other users" at: > > http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm > > If you are sending them the Template in which you have the references set, > they shoud be maintained. > > > -- > Hope this helps. > > Please reply to the newsgroup unless you wish to avail yourself of my > services on a paid consulting basis. > > Doug Robbins - Word MVP > > "Zoltar54" <Zoltar54[ at ]discussions.microsoft.com> wrote in message > news:C21139BE-D60F-46C9-A413-977F50CE6806[ at ]microsoft.com... >>I have created a VBA program and will now be sending it to a few users. >>My >> question is this - Will all of the references to the Jet and DAO db >> still >> work on the new users PC or do they need to set them manually? > >

Re: Sharing MAcros/Templates Zoltar54 21.02.2006 13:46:31 Jezebel, Would you advise that I use ADO/Jet references? And if so will that require that I re-program? Z "Jezebel" wrote: [Quoted Text] > There's no guarantee that JET/DAO will be available on a new PC. Usually it > is (if only because there's still a lot of legacy software around that uses > it); but I've seen at least one corporate configuration of new XP machines > that didn't include it. > > > > > "Doug Robbins - Word MVP" <dkr[ at ]REMOVETHISmvps.org> wrote in message > news:%23jiZsqjNGHA.2916[ at ]tk2msftngp13.phx.gbl... > > See the article "Distributing macros to other users" at: > > > > http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm > > > > If you are sending them the Template in which you have the references set, > > they shoud be maintained. > > > > > > -- > > Hope this helps. > > > > Please reply to the newsgroup unless you wish to avail yourself of my > > services on a paid consulting basis. > > > > Doug Robbins - Word MVP > > > > "Zoltar54" <Zoltar54[ at ]discussions.microsoft.com> wrote in message > > news:C21139BE-D60F-46C9-A413-977F50CE6806[ at ]microsoft.com... > >>I have created a VBA program and will now be sending it to a few users. > >>My > >> question is this - Will all of the references to the Jet and DAO db > >> still > >> work on the new users PC or do they need to set them manually? > > > > > > >

Re: Sharing MAcros/Templates "Jezebel" <warcrimes[ at ]whitehouse.gov> 21.02.2006 21:47:16 That's quite a big question. ADO is the newer technology and has a lot of features that DAO does not have. If you've already written your app, this is probably irrelevant. Changing from DAO to ADO will involve re-programming. How much depends on the app. DAO is simpler and easier to work with. You'll also have your own learning curve to deal with. If most of your database work is done through SQL statements, there won't be all that much to change, although ADO's SQL syntax is slightly different. DAO is quicker than ADO for some types of application. "Zoltar54" <Zoltar54[ at ]discussions.microsoft.com> wrote in message news:6B0442DF-558F-40F0-A7AA-47CA5A213F87[ at ]microsoft.com... [Quoted Text] > Jezebel, > > Would you advise that I use ADO/Jet references? And if so will that > require > that I re-program? > > Z > > "Jezebel" wrote: > >> There's no guarantee that JET/DAO will be available on a new PC. Usually >> it >> is (if only because there's still a lot of legacy software around that >> uses >> it); but I've seen at least one corporate configuration of new XP >> machines >> that didn't include it. >> >> >> >> >> "Doug Robbins - Word MVP" <dkr[ at ]REMOVETHISmvps.org> wrote in message >> news:%23jiZsqjNGHA.2916[ at ]tk2msftngp13.phx.gbl... >> > See the article "Distributing macros to other users" at: >> > >> > http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm >> > >> > If you are sending them the Template in which you have the references >> > set, >> > they shoud be maintained. >> > >> > >> > -- >> > Hope this helps. >> > >> > Please reply to the newsgroup unless you wish to avail yourself of my >> > services on a paid consulting basis. >> > >> > Doug Robbins - Word MVP >> > >> > "Zoltar54" <Zoltar54[ at ]discussions.microsoft.com> wrote in message >> > news:C21139BE-D60F-46C9-A413-977F50CE6806[ at ]microsoft.com... >> >>I have created a VBA program and will now be sending it to a few users. >> >>My >> >> question is this - Will all of the references to the Jet and DAO db >> >> still >> >> work on the new users PC or do they need to set them manually? >> > >> > >> >> >>