I have a client running a very old program using Office 97 databases (.mdb) and I believe some vb script. The client doesn't want to buy other software. It actually runs fine on Win 10 but its email feature doesn't work with Office programs newer than 2010.
At this point, I have got Access 1997 running on my PC and can open the database file and see the various tables etc. However, the guy who designed the system made use of two mdb files. One he called the mdb data file and the other is the mdb program file. The user runs the program file which in turns reads and writes to/from the data file. The data file as I said can be analysed in Access. However, when the program file is opened in Access, it runs the software program. I haven't found a way thus far to analyse the program file.
I have tried viewing the program file (mdb) in programs such as Notepad++. It mentions that the file is a Standard Jet DB. There is some readable code amongst what is mostly garbage text. This program file (mdb) doesnt hold any data, it is the interface that connects to the database file.
I realise Access 97 is so old but hoping someone might have an idea how this mdb progam file was written. I assume back then it was common to combine vb script with an mdb file?
The end game here is to try and find the code that is responsible for emailing invoices via the default email client. As I said, as of now it only works with Outlook 2010 or earlier. For later versions, an error occurs and the email isnt received by the email client program. Error msg = "can't open the mail session, check your mail application to make sure it`s working properly ". I think it uses the msmapi32.dll file. I realise that finding the code doesnt guarantee a fix but it would be nice to find it nonetheless. I am not finding anything of value in Notepad++ and I haven't found a way to analyse it in Access 97.
Any ideas would be appreciated.