/    Sign up×
Community /Pin to ProfileBookmark

how can php file on webserver communicate with msaccess database file on my computer

Copy linkTweet thisAlerts:
Oct 03.2016

hi all

i have a microsoft access database file on my computer hard drive

is it possible to update this ms-access file with php file that is hosted on linux web server ??

can this ms-access file communicate with my php file that is hosted on my linux web server online ??

i want to update this ms-access database file when ever i update my mysql database online with php

or can it be done vice-versa ??

when ever i update this ms-access database file on my computer, it should update my mysql database data on web server online ??

is is possible ??

i tried it with ODBC and it worked fine on my xampp server on my computer ??

but how will i make this ms-access file communicate with my php file that is hosted on my linux web server online ??

vineet

to post a comment
PHP

4 Comments(s) ↴

Copy linkTweet thisAlerts:
@ginerjmOct 03.2016 — LOL. How many ways can one say the same thing? Very clever writing.

As for the question - I don't think you can do literally what you ask. You could however perhaps upload the Access file to the server, build a real database table and then use the php script to update that and then use it as your REAL database instead of the ancient Access tables.
Copy linkTweet thisAlerts:
@NogDogOct 03.2016 — The only way I could imagine it could be done would be to open up a port on your PC to allow database access (along with whatever fiddly stuff would be required to do that). The downsides are that if your IP is not static, whenever it changes, you'd have to change the DB address on your web server app. Also, that would mean every DB query would have to do a round trip from the server to your PC and back, which would be significantly slower than to a co-located DB server where your web server is. Oh, and that would leave your PC open to attack if you don't set up everything per best security practices (and even then, who knows?).
Copy linkTweet thisAlerts:
@vinpklauthorOct 03.2016 — The only way I could imagine it could be done would be to open up a port on your PC to allow database access .[/QUOTE]

hi Nogdog

do you have any instruction or article related to how to open a port on my pc to allow database access

thanks

vineet
Copy linkTweet thisAlerts:
@TrainOct 03.2016 — Googled -open port for db access

https://www.google.com/?gws_rd=ssl#q=open+port+for+db+access

About 19,700,000 results (0.79 seconds)

Google is your friend.
×

Success!

Help @vinpkl spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...