[AccessD] Access to SharePoint

Good Morning Everyone,
 
I have an access 2007 that I am looking to move to SharePoint.  Does anyone have any experience doing this?  Will VBA code work in SharePoint?
 
If I would move the program to Access 2010 how would that change things?
 
Thanks for the help!
 
Dale