Hello everyone,
First to say this is one excellent program, that will I am sure of it save me many hours of my time.
But as always there are beginners problems included <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7621&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />
Let me begin in order with my problem <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=7621&image=2&table=forumtopics' class='bbc_emoticon' alt=':)' />
My plan is to make a application (inventory tracking of some sort) that will be used in my campus (maybe 300 users). It will be placed on to USB memory stick.
This was my plan initially:
- Convert my MS Access DB using PHP runner
- Use the generated files with portablewebapp (http://www.portablewebap.com/)
- Use the program
But, I have run in several problems already. First problem is License. Since my project will have commercial side (even though there will be no money making) I cant use MYSQL, since it is not free.
Portableweb application supports SQLlite which is totally free.
My question is:
How do I process my MS Access DB and obtain SQLite Source file? What I want to do is build a DB using that file and run my application
Another side question (regarding MySQL):
When I convert MS Access DB, I can manipulate it in a lot of ways, but one thing eludes me. How do I recreate a MySQL DB either on localhost or remote server? IN another words where is the .sql or .txt file that holds the DB structure?