My mother is a collector of folk dances and a number of years ago I made her a database to manage the thousands of dances and tracks. This is the only thing that my mother uses MS Access for, so it is not a good investment for upgrading to newer versions. Therefore, I've a long-term goal of moving it to a web-based platform.
The database includes a number of records that contain a path to an audio file, and in the form there is a 'play' button which launches the file in Windows Media Player. Behind this was code taken from here:
http://www.mvps.org/access/api/api0018.htm
This worked well prior to a recent computer upgrade (my mother moved from 32-bit Windows XP running Access 2000 to 64-bit Windows 7 running Access 2000.). Since the upgrade it has become intermittent, working with some files but not with others. My suspicion is that it is something to do with the architecture, as there is no obvious difference between the files (format, restricted characters in file name, etc.).
Until the database is replaced with a web application, I need a short-term solution that will take the file path as an input and open the file in Windows Media Player. This doesn't need to be fancy, but an escape in case of an error (e.g. can't find file) would be a useful luxury.
Thanks
Stuart
The database includes a number of records that contain a path to an audio file, and in the form there is a 'play' button which launches the file in Windows Media Player. Behind this was code taken from here:
http://www.mvps.org/access/api/api0018.htm
This worked well prior to a recent computer upgrade (my mother moved from 32-bit Windows XP running Access 2000 to 64-bit Windows 7 running Access 2000.). Since the upgrade it has become intermittent, working with some files but not with others. My suspicion is that it is something to do with the architecture, as there is no obvious difference between the files (format, restricted characters in file name, etc.).
Until the database is replaced with a web application, I need a short-term solution that will take the file path as an input and open the file in Windows Media Player. This doesn't need to be fancy, but an escape in case of an error (e.g. can't find file) would be a useful luxury.
Thanks
Stuart
