Is there an APP that accesses a Microsoft Access Database and its forms?

These (looks like some synchronization between PC and Android, so probably won't work with raw Access data) :
MS Access for iPhone,iPad,Android,Blackberry,Tablets | Database Application for Mobile Phones
Cellica Database for Android

I've just started using Cellica and it seems to work quite well. I use the WiFi version so that I can sync my data over my local network via wifi. There is another version which will sync via the internet. There is a desktop part which you have to buy if you want to sync databases but it also alows you to design forms and these are synced with your data. The Cellica support team are very good and have responded quickly to my queries and even designed a form for me when I was having trouble trying to get something to work.

I only have a niggle about the column widths on grid controls. They can be widened but always revert back to default widths when you come back to the form. However, despite this irritation I find the product useful and it means I can have my databases with me.

Cellica only has a fraction of the features that Kaione's SprintDB Pro on Windows Mobile has but I can't find anything better. HandBase have an Android version but it doesn't have the capability of forms. I asked Kaione about an Android version and they told me they are developing one but can't say when it will be available so it could be a long time. In the meantime I'll stick with Cellica.

Pendragon Forms VI claims to work with Android, but I haven't had much luck with it so far. We use it for our Palm based phones and it syncs with our SQL Server database just fine.

Cellica seems like it's worth a try too.

kejlyCZ said:

These (looks like some synchronization between PC and Android, so probably won't work with raw Access data) :
MS Access for iPhone,iPad,Android,Blackberry,Tablets | Database Application for Mobile Phones
Cellica Database for Android

Click to expand...

Both are wonderful app. But When compare to Cellica, AccessReflex is much cheaper and user friendly.

i suggest Accessreflex. Give a try............

I tried Cellica and AccessReflex. both are good.

AccessReflex did not allow me to update data from device and also could not create forms for my DB.

Cellica Database did the gr8 job, able to get GPS co-ordinates as well as able to scan Barcode data on my Galaxy Tab and submit it to my Access database which was in my office. Form are impressive.

Hi jimmy,
I need only to view and execute few MS access queries in my mobile. For that AccessReflex will be better option for me.

Hi,

As in Offline Mode, you can view all Access Database Files into Excel Sheets.

If you directly want to view all ACCDB Files you can use two ways

Manual Method:

Creating an Android SQLite data source

Open the Database tool window by selecting View | Tool Windows | Database from the main menu.
Click /help/img/idea/2017.2/new.png on the toolbar and select Android SQLite from the drop-down menu.
In the Data Sources and Drivers dialog that opens, specify the following:
The name of the data source.
The physical or virtual device where the target database is stored. If no devices are available in the drop-down list, this means that there are no running devices connected to IntelliJ IDEA. Run and connect a physical device or launch an emulator.
Specify the name of the application package the target database is associated with. For more information about application packages Android documentation. Select a package name suggested by IntelliJ IDEA or type its ID.
For the database to be accessible, the corresponding application must be built as debuggable and installed on the device or the emulator.

IntelliJ IDEA run configurations, by default, build Android applications in the debug mode. Alternatively, you can generate the APK in the debug mode.
In the Storage area, specify where the database is located:
Choose Internal if the database is stored in the internal memory of the device or the emulator.
Choose External if the database is stored in the external memory of the device or the emulator.
In the Database drop-down list, specify the database name or location:
If the database is stored in the internal memory, choose the database name.
If the database is stored in the external memory, specify the database location relative to the memory root. For example, Android/data/<application_ID>/<database_name>.
If the necessary SQLite driver files are missing, download them by clicking the Download link at the bottom of the dialog box.

See also, Managing data sources.

Otherwise, you can also use free version of the following tool to analyze your files

http://www.taskmanagerfix.com/access-database-viewer.html


Regards
Max Persian