Have PC Deterime the Correct Version of Access to Open

[dave sharpe]

I'll soon be forced to have Acc2k and AccXP on My
PC at work.

I found reference to an interesting article the seems
to say its possible to click on and MDB and automatically
open it with the correct version on Access. One needs to
be a subscriber to "ACCESS-VB-SQL ADVISOR" to actually
view the article.
----------------------------

http://advisor.com/doc/11343

Open Microsoft Access in the Correct Version
Most Access developers have multiple versions of
Access installed on their machines, here's how to
make the right one, not necessarily the most recent one, open.

By Doug S.
December 2002
Length 1 page
On page 49 of the magazine.

Article Summary:
Here's a simple workaround to ensure the version of Access you
want opens when you click on an .MDB file.

If anyone in the group knows how to do this, I'd appreciate
it if You would share.

Thanks

Dave

 

[John Spencer (MVP)]

I don't know what the article said. I do this for myself by setting up
shortcuts that reference the correct Access Application (.exe) followed by the
database I've developed. Then I use the shortcuts to launch by databases. An
example target string might be:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\My Documents\EPSDT_FE_M.mdb"

 

[dave sharpe]

John

Thank You for the pointer.

Through another source, I was provided the following.

"Here is a free download to do exactly what you want.
http://www.aadconsulting.com/ezacc.html ".

I thought that you benefit from it.

Dave

 

[John Spencer (MVP)]

Access 2000 and Windows 2000.

I put the reference to Access 2000 and then follow that with the reference to
the specific target mdb all in the Target control. I surround each reference
with quotes.

"Reference to Access exe" "Reference to MDB"



As far as the Start In. I either clear it completely or I set it to the
directory for the Access application.