Microsoft Access

Why can't Libre Office read my database files?

Libre Office

Episode 1710

Dale from Dallas, TX

Dale updated to Windows 10, and it screwed up his laptop. He had it all fixed, and it turned out to be a dead hard drive. So he has a new hard drive, but now the program he wrote in Access to collect his library of books won't open in an open-source database like Libre Office, while it worked before. What can he do? Leo says as long as Dale has the original Access database file, he should be able to convert it into something more easily readable by Libre Office. Dale can also try using the free Microsoft Access Runtime utility to read the database file directly.

Can I view a database on my mobile phone?

Episode 1543

Mark from Castaic, CA

Mark would like to sync his iPhone with a Microsoft Access database. Leo says there are several third party clients like Access Frog, Access Database Manager, ACCDB, and Pocket Access. He can also navigate to his Access database through his Safari browser. He'll need to configure his database so it can be read online, however, and that could be a security issue.

How can batch print PDFs automatically?

Microsoft Access

Episode 1472

Frank from Fontana, CA

Frank wants to timestamp PDF blueprints that he prints up, and he wants to be able to print them in order by group number and file name. He's created a database in excel to do this and then created a batch file. Leo says this is how programmers are born, by creating scripts and macros to streamline the workflow. Leo also says that a database program would be easier and can be done automatically. It would also allow him to create the PDF from the database and when he makes changes, the PDFs will be updated automatically.

How can I have a mobile copy of my database?

Episode 1356

Bill from San Gabriel, CA

Bill can't access files on an old XP machine unless he logs into an intranet and connects to it remotely. He can't see them if he logs onto the computer directly. Leo says if he has access to the machine remotely, he should be able to copy the files to another computer, or even a thumb drive. Any change he makes to the database will not populate to the shared version, though. He'd have to sync to them. It would be better to make them read only and not make changes until he updates the local copy of the old machine.