Printable View
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. :sick:
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.
Thank you for your quick response. I'll give it a shot and see what happens.
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#
# 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.)