MDB Explorer for Android

I just want to open an access db&form but it runs out that paying $10 for this program does not give you that ability; you have to pay another $10 to open a file. Instead of doing that I will go compile the mdbtools off of github. Ugh, why would someone do this.

Description of app doesn’t make buyer aware of in-app purchases to actually use this product. You would have to create an MDB file from Access to use this (If you could that on your Android you wouldn’t need this App to begin with!)

Don’t waste your money. Can open files but the filter function is useless. Crashes every time I use it. I have to find a new app. I want my money back!!!!!!!!!!!

I downloaded this to convert an MDB file to SQL, in order to import it into a SQL Server instance. The interface was good and the export was a seamless affair; it was quick and easy. Until I attempted to run the exported SQL script on SQL Server 2012. There were a lot of syntax issues with unique indices (I had to remove the schema definitions by hand), and the SQL generated for foreign keys doesn’t work well. It’s possible that some of the foreign key isues are due to the way that the Access database was set up, but I’m having to edit the SQL by hand to make this work correctly. Of note: if you have an Access database that uses the “varbinary” type, and you export as MSSQL, the syntax will be incorrect; it uses the MySQL variant for the value insert (ex: x’589cf’) instead of the MSSQL hexadecimal syntax (ex: 0x589cf) so you’ll have to do a find and replace. Overall, it’s not bad, compared to a lot of the alternatives, but just be aware that it requires tweaking.

I used to love this app because I used it to convert from Access to SQLite. In a recent update they made Access DB format an additional $5.00. I purchased this app once, I won’t purchase it again for a feature I “bought” the first time around.