Learn MS Access 2003

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.

edit ms access2003 1 Learn MS Access 2003

you’ll see the application in design mode (you can access; tables, queries, forms and reports etc under objects)

edit ms access2003 2 Learn MS Access 2003

Fix ‘invalid path error message” when you open ms access 2003 application

open the application and click Tools -> Database Utilities -> Linked Table Manager

edit ms access2003 3 Learn MS Access 2003

 

 

 

 

 

 

 

select the linked tables to be updated and click OK.

edit ms access2003 4 Learn MS Access 2003

wait for a while, new pop up will appear telling if ‘all selected linked tables were successfully refreshed’

edit ms access2003 5 Learn MS Access 2003

Change ms access 2003 application title name

click Tools -> Startup

edit ms access2003 6 Learn MS Access 2003

change application title as seen on the picture and click ok.

edit ms access2003 7 Learn MS Access 2003

Open code editor for ms access 2003 forms

choose forms and click ‘code editor’ icon

edit ms access2003 8 Learn MS Access 2003

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.

See you!