Changing databases in VB 2005

[lover1969]

I hope someone can offer me some advice on this issue.

I created a running program in VB 2005 Express Edition using a MySQL database. I have over 400 lines of code. How difficult would it be to change this program over to an Access database? I installed a converter that converts the MySQL database over into an Access database. How will this effect my program in VB? Would it cause me to have re-code the whole entire program? Any help or suggestions would be greatly appreciated.

[Hack]

Different connection string, and possible different Imports (I'm not familiar with MySQL), however, if the table structures are identical, then that would be the only coding changes.

[lover1969]

Thank you for your quick response. I'll give it a shot and see what happens.

[rasinc]

I'm not 100% sure it is mandatory but I have always coded SQL statements on an Access database surrounded with # eg. #03/28/2008#

[Hack]

# signs would be for dates, not SQL statements and the # signs are unique to Access and not required, or supported, in other databases (at least none of which I'm aware.)