[AccessD] Ya just gotta love it

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.

I have written this CopyAndRun application for copying the FE and libs to the user's workstation and 
opening it.  C&R uses office automation to open the file just copied.

This is the code which actually opens the application just copied.

Sub OpenApp(strFEToOpen As String)
Dim appAccess As Access.Application
     ' Create new instance of Microsoft Access.
     Set appAccess = CreateObject("Access.Application")
     ' Open database in Microsoft Access window.
     appAccess.OpenCurrentDatabase strFEToOpen
End Sub

One of the users has Access2K SP1 installed, and when he uses C&R it does in fact open the target 
app but it is hidden, i.e. there is an Access process in Task Manager Processes but Access is not 
listed in Applications.

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?

-- 
John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it