A client want me to convert their application that use MS Access 2003 to web based application using php and mysql. I agree to do so and this post is just for myself future reference when I have to deal with other MS Access 2003 application.
Open MS Access 2003 in design mode
double click access file, choose block unsafe and click open button when you see ‘security warning’ menu.
while you click open button, make sure to press shift key.
you’ll see the application in design mode (you can access; tables, queries, forms and reports etc under objects)
Fix ‘invalid path error message” when you open ms access 2003 application
open the application and click Tools -> Database Utilities -> Linked Table Manager
select the linked tables to be updated and click OK.
wait for a while, new pop up will appear telling if ‘all selected linked tables were successfully refreshed’
Change ms access 2003 application title name
click Tools -> Startup
change application title as seen on the picture and click ok.
Open code editor for ms access 2003 forms
choose forms and click ‘code editor’ icon
new visual basic window will open, you can see the logic there.
convert ms access to mysql
I’ll update the post when I’m done with it.
Update : learn how to convert ms access to mysq step by step.