>> currentDb access.application Jonathan 12/30/2008 3:39:00 AM Hi is there a way to reference the access.application object of the current database? I have more than one version on my machine. Even though I am running an application in Access12 using set acApp=CreateObject("Access.Application12") returns 11 for acApp.version Many thanks, Jonathan

RE: >> currentDb access.application Jonathan 12/30/2008 3:51:01 AM funnily enough I got it just after posting this.... set acApp = Access.Application doh! Thanks anyway, Jonathan "Jonathan" wrote: [Quoted Text] > Hi is there a way to reference the access.application object of the current > database? > > I have more than one version on my machine. Even though I am running an > application in Access12 using set acApp=CreateObject("Access.Application12") > returns 11 for acApp.version > > Many thanks, > Jonathan

Re: >> currentDb access.application Tom van Stiphout <tom7744.no.spam[ at ]cox.net> 12/30/2008 4:11:11 AM On Mon, 29 Dec 2008 19:51:01 -0800, Jonathan <Jonathan[ at ]discussions.microsoft.com> wrote: Set acApp = CreateObject("Access.Application.12") would likely have worked as well. -Tom. Microsoft Access MVP [Quoted Text] >funnily enough I got it just after posting this.... > >set acApp = Access.Application > >doh! > >Thanks anyway, >Jonathan > >"Jonathan" wrote: > >> Hi is there a way to reference the access.application object of the current >> database? >> >> I have more than one version on my machine. Even though I am running an >> application in Access12 using set acApp=CreateObject("Access.Application12") >> returns 11 for acApp.version >> >> Many thanks, >> Jonathan

RE: >> currentDb access.application Jonathan 12/30/2008 4:17:01 AM Unfortunitely is was not as easy as that. What I need is to open another session of an Access Application. Online help suggests that you can open access12. However the object browser does not include access12 as an option... I seem to be going around and around this issue of having more than one version of access installed so that I can support multiple access versions (for example, you can only create a version 10 .mde using access10 otherwise access10 cannot open the database. This is even though you can make changes using access11). Jonathan "Jonathan" wrote: [Quoted Text] > funnily enough I got it just after posting this.... > > set acApp = Access.Application > > doh! > > Thanks anyway, > Jonathan > > "Jonathan" wrote: > > > Hi is there a way to reference the access.application object of the current > > database? > > > > I have more than one version on my machine. Even though I am running an > > application in Access12 using set acApp=CreateObject("Access.Application12") > > returns 11 for acApp.version > > > > Many thanks, > > Jonathan

RE: >> currentDb access.application Dale Fye 12/30/2008 1:04:00 PM Yes, running multiple versions can be a pain in the butt. Although I never really had any problems until Access 2007 came along. Now it takes forever to load 2007 after having used 2003 or XP. -- Dale email address is invalid Please reply to newsgroup only. "Jonathan" wrote: [Quoted Text] > Unfortunitely is was not as easy as that. > > What I need is to open another session of an Access Application. Online help > suggests that you can open access12. However the object browser does not > include access12 as an option... > > I seem to be going around and around this issue of having more than one > version of access installed so that I can support multiple access versions > (for example, you can only create a version 10 .mde using access10 otherwise > access10 cannot open the database. This is even though you can make changes > using access11). > > Jonathan > > > "Jonathan" wrote: > > > funnily enough I got it just after posting this.... > > > > set acApp = Access.Application > > > > doh! > > > > Thanks anyway, > > Jonathan > > > > "Jonathan" wrote: > > > > > Hi is there a way to reference the access.application object of the current > > > database? > > > > > > I have more than one version on my machine. Even though I am running an > > > application in Access12 using set acApp=CreateObject("Access.Application12") > > > returns 11 for acApp.version > > > > > > Many thanks, > > > Jonathan

Re: >> currentDb access.application Dale Fye 12/30/2008 1:26:01 PM Rick, I don't think so, but have not figured out how to determine what the current SP is in 2007. What happened to the Help -> About menu option in Access 2007? -- Dale email address is invalid Please reply to newsgroup only. "Rick Brandt" wrote: [Quoted Text] > On Tue, 30 Dec 2008 05:04:00 -0800, Dale Fye wrote: > > > Yes, running multiple versions can be a pain in the butt. Although I > > never really had any problems until Access 2007 came along. Now it > > takes forever to load 2007 after having used 2003 or XP. > > Do you have SP1 for 2007 installed yet? While the delay is still there > it is considerably shorter after SP1 is installed. > > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com >

Re: >> currentDb access.application Dale Fye 12/30/2008 1:56:12 PM It is in the Access Options - Resources tab. See the attached: http://blogs.msdn.com/jensenh/archive/2006/05/02/588352.aspx -- Dale email address is invalid Please reply to newsgroup only. "Rick Brandt" wrote: [Quoted Text] > On Tue, 30 Dec 2008 05:26:01 -0800, Dale Fye wrote: > > > Rick, > > > > I don't think so, but have not figured out how to determine what the > > current SP is in 2007. What happened to the Help -> About menu option > > in Access 2007? > > I have no freakin idea, but you can be sure that when you finally find it > it will be in a place that is actually easier to find than where it has > been for the last 15 years. I'm sure Microsoft has done numerous studies > proving that fact :-) > > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com >

RE: >> currentDb access.application "David W. Fenton" <XXXusenet[ at ]dfenton.com.invalid> 12/31/2008 2:41:51 AM =?Utf-8?B?Sm9uYXRoYW4=?= <Jonathan[ at ]discussions.microsoft.com> wrote in news:421BBF25-408D-4B02-8AD2-D081218FF722[ at ]microsoft.com: [Quoted Text] > What I need is to open another session of an Access Application. My bet is that you actually don't need this at all. Please explain why you think you *do* need it and perhaps someone can provide you an approach that doesn't require another instance of Access. For what it's worth (and that's very little), I've made my living programming Access applications since 1996 and have never even once found a need to open another instance of Access from within Access. -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/