Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Converting MSAccess "SQL" queries to MySql compatible queries

Status
Not open for further replies.
audixdude

audixdude

Programmer
Apr 10, 2002
4
ZA
I have been working on a large web project using Win98/ASP/MSAccess97. Recently we have had to convert the entire project to run under Unix/PHP/MySql. The ASP and the Database have successfully been converted to PHP/MySQL. However we need to convert all of the "phoney" SQL queries used by Access to run under MySql. Does anyone know of a plugin/package that can do these conversions automatically. I have over 200 pages that need converting! The thought of doing them all manually is NOT very exciting :)
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
222
EdZzy
E
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
391
Chris Miller
Chris Miller
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
431
lupidol
lupidol
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
473
dylim
dylim
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
331
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top