Let me explain my exact requirement. I have built one POS (Point of Sales) access db for my friend. So far it's going fine. But today I made a mistake on entering the custom price for a customer (I typed 3 instead of 35 in quantity so they lost almost a 1000 bucks in INR). My current idea to prevent this in future to restrict the Data Entry only once instead of noting that in papers during customer calls and then entering separately in to the system. So I need a mobile interface just to note the following Details:
Who is the Customer?
What all are the Items He wants to purchase?
And How many items?
So I need a mobile interface to note the above details at the time of call itself. How to do this? Please Help. Thanks for reading.
What is the shortest possible way to achieve this?
Personally for mobiles I would use php/html. Some providers use My SQL and usually its free with client packages, others Sqlserver.
If they use My SQL then you should be able to connect to their database via a ODBC connection and import the data stored in that table, into your main access suite.
years ago i had a spare PC running access with a remote descktop connection like Teamviewer.