Do I need to re-create forms from scratch that were originally created in Access 97/ Access 2000 / Access 2003?
Can I import the form into the new accdb just redo the code behind the forms (and modules) (lots of code / very complicated application)
If the answer is re-create - please explain WHY.
I built the application 20 years ago to do complete accounting, invoicing, etc for a catering company that wasn't that big at the time. Now they are big and I'm moving it to a SQL Server backend, but I would prefer just to change the code and such on the forms (also and some fields) and not recreate 100 plus forms. I am using Access 2010 to build the application even though it will be installed in an Access 2016 environment.
Thanks in advance for any advice you can give me.