Convert AccessBasic97 to AccessBasic2007

[Guest]

Has anyone tried to convert AccessBasic97 code to AccessBasic 2007. Is it as
simple as cut and paste or is Access Basic2007 really different from
AccessBasic97?

 

[AnandaSim]

Has anyone tried to convert AccessBasic97 code to AccessBasic 2007. Is it as
simple as cut and paste or is Access Basic2007 really different from
AccessBasic97?

Access Basic was a peculiar dialect used in Access 1 and 2, same as
WordBasic was used in Word 1 and 2. From Access 95 onwards, we have
had VBA - there have been binary changes and new, extra commands
introduced each version, but the language has not changed in
sourcecode.

In short, VBA/Access 2007 is pretty much the same as VBA/Access 97

HTH
Ananda

 

[Allen Browne]

Simple, well-designed code from Access 97 database works without
modification in Access 2007.

For details of issues you could face, see:
Converting from Access 97
at:
http://allenbrowne.com/ser-48.html

For more info about problems specific to Access 2007, see:
Converting to Access 2007
at:
http://allenbrowne.com/Access2007.html