Access 2016 Database to Java

[Clepto]

I wish to create an app to run on Android and iPhones, but I have never used Java. I have created a working model as an Access 2016 application. The application is fairly simple, with half a dozen tables; the biggest of which has 10 attributes with no more than about 50 lines of data.

Now I wish to reproduce the database in Java.

The converters that I can find on the internet are only compatible with Access 2003 or earlier.

Short of me spending some considerable time learning to write applications in Java; does anyone know if there are any converters available that can convert an Access 2016 database into Java, or is there a method I can follow that can convert the various components of the database into Java?

Any tips or advice will be much appreciated.

 

[CJ_London]

not really, you'll need to start from scratch, although at least you have your table structure and relationships finalised. Alternatively convert your db back to 2003 (may need an earlier version of access to do that). Either way, I don't think it will be a case of click a button and hey presto, my access app is now a java app.

The converters usually offer a free 'trial' which will convert a .mdb northwind database to a java equivalent. However I've no idea how effective it is.

When I started learning Java, I developed some simple apps in parallel with access so I could 'see the differences'. Also dipped into different online tutorials to learn how to do specific tasks.

It really isn't a case of changing a few words - many controls need to be built up from smaller components - which gives you much more flexibility of what they look like and many more events to trigger code, but additional complexity in managing them.

Basic maths code is very similar but java is much more object orientated - if you make extensive use of class modules, you will be much closer to the mindset required.

As with many languages there is often more than one way to accomplish something - you will find plenty of debates on java forums which can be very confusing until you start to learn to separate the wheat from the chaff and understand the terminology - just google 'java combo box' to see what I mean

 

[Clepto]

Many thanks on that. I suspected as much when I did not get a dozen instant answers.
I have an old computer with Windows 2000 Professional on it. It will be easy to replicate the tables in that and I trust that the VBA modules will transport as they are. I can transfer the queries to SQL and run them as strings in VBA. Then I will be able to see if the Diamond Edge converter does what they say it does.
Thanks again