MS Access Frontend to MySQL Web Server

[tsunade]

---

I need your ideas:
Pros & Cons..

Naa nakoy nahimo nga FE (Frontend) ug BE (Backend Mysql).. locally nindot iyang performance pas2x.. pero unsa kaha kung ako ning e adto sa web, nya unsa-on sad pag connect via SSH "the probs. is i dont have access to SSH" wala me hatage ug access sa among webhost.
..can i connect via mysql ODBC to my webserver.. need nako advices sa mga IT pros.

[fixyourself]

wa ko ksabot.. tarunga dawg pangutana... og unsai MS-ACCESS front end? tapos unsai kalabot sa SSH?

[tsunade]

wa ko ksabot.. tarunga dawg pangutana... og unsai MS-ACCESS front end? tapos unsai kalabot sa SSH?

...naa koy MSAccess+MYSQL via WAMP nga application.. sa local "LAN" ok kaayo siya wala problem.. pero gusto ta nako ebutang nako ang Backend ngadto sa among Webserver/Webhost/Internet.. unsa kaha ang paagi sa pag connect sa MSAccess frontend ngadto sa net/mysql.

SSH = Secure Shell.. i tried PuTTy to connect pero dili ko ka connect via SSH kay wala me taga-e access sa webhosting company..

naa ba laing paagi ani..

[tsunade]

please close na lang ni mga master.. i got a solution na.. thnx.
solution: i have to re-write everything from scratch to PHP.. kay wala gyuy lain mas immediate ug lowcost nga pa-agi. hinoon simple rani nga system. just data entries for sales (not a POS)

thnx anyway

[vensoy]

aw.. sulbad na diay ni bro.. wala lage ni ge close sa mod.

[SYNCH]

please close na lang ni mga master.. i got a solution na.. thnx.
solution: i have to re-write everything from scratch to PHP.. kay wala gyuy lain mas immediate ug lowcost nga pa-agi. hinoon simple rani nga system. just data entries for sales (not a POS)

thnx anyway

What you actually made is a long-term fix which is great. And it sounds like it was easy to migrate so that's good. However, if it was a large application, migration is probably the last thing on your mind. A quick fix would have been to open the MySQL port (?3306) on your webhost, that is if you have access, and grant permissions to the client IP address that will be accessing the database. Change the connection string of your client apps to connect to your server using the IP address scheme and you're good to go. Of course, this excludes any security issues, etc.

Note, since you were not given access to SSH, there is 90% chance you are not allowed to open ports too. However, you are not yet stuck but I don't think it's still relevant to talk about the other possible solutions.