/    Sign up×
Community /Pin to ProfileBookmark

msaccess 2 php

Copy linkTweet thisAlerts:
Apr 02.2008

dear developers,

i have an issue that bother me for 2 days.
im working at the service company, repairing and maintenance used cars.

u c, there’re gate officers( in and out ), finance mgt, accounting and public relation/customer service officers. but since the pr/cso had left, the boss want to replace him with a website.

so everytime the gate officers input data ( they’re using ms access ), the finance and the accounting will have the report. Then The boss wants the website to be dynamic. He wants it to be able to provide data to the customers about what repairing we have done to their cars.

For example,
we have 300 customers. All of them who has register will be given username and password. so they only need to go to the website.

we already have a static web on an apache hosting. so the suitable must be mysql for database.
1. how can it be done? how to colaborate ms access and mysql?
2. is there a script available to update automaticly from gate to the website?

thx and regards

to post a comment
Full-stack Developer

8 Comments(s) ↴

Copy linkTweet thisAlerts:
@scragarApr 02.2008 — http://php.net/manual/en/ref.uodbc.php

not hard, but annoying unefficient.
Copy linkTweet thisAlerts:
@ray326Apr 03.2008 — Move the data used by the Access application into MySQL tables. Access isn't tied to Jet.
Copy linkTweet thisAlerts:
@rendraauthorApr 03.2008 — not hard, but annoying unefficient.[/QUOTE]
Move the data used by the Access application into MySQL tables. Access isn't tied to Jet.[/QUOTE]

dear you thx for the quick reply ...

can you tell me in short of

1. how to make it efficient?

2. how to move access to mySQL using automatic script
Copy linkTweet thisAlerts:
@ray326Apr 03.2008 — 2. how to move access to mySQL using automatic script[/QUOTE]Nope. It would be a one time manual export/massage/import then a change to the Access application to use the MySQL database directly from that point on.
Copy linkTweet thisAlerts:
@rendraauthorApr 04.2008 — so the only option is to replace the php to asp side?
Copy linkTweet thisAlerts:
@ray326Apr 05.2008 — You said it was an Access application, not ASP. Which is it?
Copy linkTweet thisAlerts:
@rendraauthorApr 07.2008 — yup .. it's an ms access application

as i said earlier, the boss wants the access database to be able on the web as well. But the web was writen in PHP. as it gone be though and quite annoying unefficient like scragar said (although it's still possible) ... in order to develope an easy coding and programing ... i'm rethinking to mode the php base to asp web base ...

how do you thing??
Copy linkTweet thisAlerts:
@ray326Apr 07.2008 — If you're going to move to ASP then I'd move the whole thing to SQL Server.
×

Success!

Help @rendra 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 5.25,
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: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

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

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...