Two Versions of Access on my hard drive

[Mechele]

Would having Microsoft Access 2002 and 2003 on my hard drive cause me to have error with my code?

 

[boblarson]

It shouldn't, but there are some features available in 2003 that weren't in 2002. But, if you stick with the A2K format, then you should be fine for both (including A2K).

 

[gemma-the-husky]

i have both -

one problem is that an mde built in A2003 wont run in A2002

out of interest, i did have an app that used before update events to cancel actions (check box clicks), after storing what the action was for future reference

worked fine in A97 -
slightly wrong in A2002 -
completely wrong in A2003 - wouldn't exit the check box

 

[jwhite]

Mechele,

aadconsulting.com has a free utility called Access Dashboard that will give you a tree directory view, with MDB's on the right. Double click an MDB file - if you have that version of Access installed it opens it; if not, it doesn't open it. http://www.aadconsulting.com/addins.html. Handy for those having to work with multiple versions of Access MDBs.

 

[Len Boorman]

Got 3 versions on my HD.

Basically I use a tweaked shortcut on desktop to open application with correct access version

Add ":\Path to MSACCESS.exe you want to use" before the "Database path"

Leave a space where I have typed between.

Then you always open application with correct version

L