[AccessD] Ya just gotta love it

Not ideal, but logical.

If 2002 is the registry "default" for Access, that's what COM ( or whatever MS are calling it 
these days)  will use when creating the appAccess object.   

-- 
Stuart   

On 28 Dec 2011 at 9:50, jwcolby wrote:

> On my workstation at the client I have Access2K and AccessXP (2002) installed.  Access 2002 is the 
> one that opens if I just double click a database.
> 
...
> Dim appAccess As Access.Application
...
> So I try testing it with my system.  I use a shortcut to Access 2K (which has SP3) to directly open 
> C&R.  I then click a test button which opens the target app.  When it opens it is running under 
> Access 2002.  IOW even though the code above is running in Access 2K once the dust settles the 
> target is running in Access XP.
> 
> Not ideal for testing eh?
>