Access to APK (1 Viewer)

[MattBaldry]

Hi Forumers,

Has anyone ever had any luck converting a database into an Android app at all?

If yes, what program did you use and any restrictions on queries or the like?

~Matt

Alternatively, has anyone had any experience in converting a simple form to a webpage?

I have a very simple lookup query that shows a value between 2 times. I just want a webpage/app to be able to use this on my phone.

 

[Pat Hartman]

Near as I can tell, there is no software that will convert an Access app to anything. You can always convert a Jet/ACE database to something but that is not the same thing. Don't believe the websites that offer products that convert "Access to a web app. They convert the database and build generic forms corresponding to each table. Some of them even support a macro language that allows you to reproduce some, just some of your Access functionality.

Even MS when they were trying to find a way to webify Access never offered a conversion. Client/Server apps do not work the same way that web apps work. If you want to "convert" your Access app to run on Android, you have to do it form by form, one line of code at a time. And you have to give up on the features that the web does not support.

You can use Citrix and Remote Desktop to run your Access app in a webpage but you will need to either host the server yourself or find a third party. You would also have to create custom forms if you want to be able to actually see things on your phone since the existing ones will not scale.

 

[Isaac]

@MattBaldry
I agree with everything Pat said, frankly I just really don't see that happening.

 

[Uncle Gizmo]

Have a look at Celica database in the play store:-

Sync Access, Excel, My SQL, SQL Server databases, Design Forms for your Android.

Sync MS Access, MS SQL Server, My SQL, Oracle, MS Excel databases on your android.

Read and Write to any desktop side MS Access, MS SQL Server, My SQL, Oracle, MS Excel database Wirelessly with your Android Phone/Tablet(3G, GPRS, EDGE or Wi-Fi). Changes on Android can synchronize wirelessly and instantly to desktop database. Also, any modifications to the desktop database can wirelessly and instantly send to Android, so you will always have the most current information at your fingertips.

Cellica Database Server on your PC can be connected to internet via your Wi-Fi router in another room, or desktop can be in your office few miles away connected to the internet.

What our clients says: http://www.cellica.com/Testimonials.html


Again, even if your Android is not connected to Wi-Fi router, Android side Cellica Database application will use your cellular data network (3G/ 4G/ EDGE/ GPRS) to send data to/from your Android from/to your Desktop.

User can work Offline when network is not available and submit data when network will available.


Features:

* Synchronize any MS Access, MS SQL Server, My SQL, Oracle, MS Excel database Wirelessly on your Android phone/Tablet(3G, 4G, EDGE or Wi-Fi).
* Add/Edit/Delete data on Android Phone/Tablet, which will be immediately transfer to database on your Computer wirelessly.
* Update data on the field, which will reflect to Server database(Desktop database).
* Synchronize Table/View or Stored Procedure of your database with Android phone.
* Apply SQL select queries, Filters, Sort the fields and sync data according to it.
* Supported Databases: Microsoft Access(.mdb,.accdb)(97 and onwards), Microsoft Excel(.xls,.xlsx)(97 & onwards), Oracle, SQLServer, DB2, MySQL, PostgreSQL, FoxPro, dBase, R:BASE,Sybase, FileMaker Pro, Firebird & any ODBC Compliant Relational Database.
* Create your own custom database on Android Device, or choose from one of the pre-designed templates such as VehicleInfo, BankAccount,MembershipInfo etc.
* Data is secured as 128 bit AES used for encryption.
* Supports Unicode language database such as Japanese, Chinese, Korean, Russian etc.
* Supported Forms on Android phone and Tablet.
* Design form on desktop with Label, Text Field, Buttons, Checkbox, Combo box, Page, Sub-form control.
* Supports Sub forms, Design a master/detail form, or a parent/child form using sub form.
* Send single record data on form as a .png image by Email.
* Image control on form, Select image on device for each record.
* Create form in Portrait/ Landscape mode.
* Import/Export form design.
* Support Bar code scanning.

Software has 10 days evaluation period.

Download and install desktop component of this software on windows based PC from the following link.

http://www.cellica.com/DownloadforAndroid.html

User Guide:

http://www.cellica.com/AndroidCellicaDatabaseUserGuide.pdf

Device side is free to download. User needs to purchase desktop software after 10 days evaluation period. Cost of desktop software is $39.99
Purchase the full version software from the following link.

Cellica Corporation - Internet Database

Cellica Corporation cares about its clients and helps them make informed decisions with well-defined methodology and end-to-end business solutions that accelerate business.

www.cellica.com

Difference between Internet version and Wi-Fi version:

Following are the additional features in this Wi-Fi version.

1. Supports Signature control.
2. Support images synchronization with desktop database.
3. Instant data synchronization in both direction.
4. No need of internet on device.


Internet version allows to synchronize data from any where.
Wi-Fi version supports synchronization of data only in local Wi-Fi area.

Wi-Fi only version is not compatible with the Internet version in terms of Syncing.


For Wifi Only version

Cellica Corporation - Wifi Database

Cellica Corporation cares about its clients and helps them make informed decisions with well-defined methodology and end-to-end business solutions that accelerate business.

www.cellica.com

For Internet version

Cellica Corporation - Internet Database

Cellica Corporation cares about its clients and helps them make informed decisions with well-defined methodology and end-to-end business solutions that accelerate business.

www.cellica.com

 

[Pat Hartman]

That looks like a useful product if you need something to run on an Android and don't need to reproduce the actual app. But it still doesn't do conversion of the Access app. Its pricing model is bizarre also. The product including 3 clients for $499 and the product including 5 clients for $950. so the second two clients cost $450 which seems excessive. It looks like the app was built by programmers familiar with Access.

 

[Uncle Gizmo]

Pat, there's a personal version for US $44.99

 

[Pat Hartman]

OK, but what is the cost for each client? The whole point is that you need to buy a client for each Android device. I wasn't complaining about the initial cost of the product. It is certainly worth the price they are charging but if you have more than a couple of clients, it becomes expensive in a hurry.