Excuse me, I've searched the forum but didn't got the answer. So I made a new post here.
I'm trying to make a e-book builder called epubBuilder to a portable app. Everything goes fine except one thing. The app stores files open history in a .mdb (Microsoft Access Database) file. Is there any solution to replace driver letter and package partial dir in mdb files? Maybe using a command-line utility? I know nothing about database.
Thanks!
Visit the Community page
Join our forums
Subscribe to our email newsletter
Subscribe with RSS
Follow us on Facebook
Follow us on LinkedIn
Follow us on Twitter
Follow us on Mastodon
Follow us on BlueSky
Generally speaking, to access/modify a database file (.mdb's included) you need to have a database driver.
Access uses Jet I am pretty sure, which, luckily, is a part of most modern Windows builds. The problem, however, is that there is no simple solution to utilize the Jet engine for making the actual changes to the file - it will involve coding of some form.
I can't tell you whether there is an NSIS solution for this, there are others here with a great deal more NSIS experience than I, but it can be done with other languages.
Basically unless Google brings you a result for a command-line tool that will do what you want, you would have to code it yourself.
Thanks for the guide.
It sounds not as simple as I expect. To my shame, to code in other language is beyond my ability now. I found a NSIS plugin NsODBC which can basically manage Microsoft Access mdb files. But it's insufficient to do word replace in file. And I haven't found a command-line tool yet. Maybe I should start learning a high-level language.
Thanks again!