still able to workd in Access 2007

[Frank Situmorang]

Hello,

I am developping our church membership database using Access 2002 in my
laptop. I plan to convert it to access97 then I create MDE using Access 97 in
my othercomputer.

My question is, with all VBA that I created, Is there any possiblity that it
can not work in Access 97?, otherwise I just make MDE access2000.

Thanks for any idea provided

 

[Allen Browne]

You may be able to save it as an Access 97 MDB.
If you plan to, do this before you split.

Of course, it won't work if you used any of the things that were not in
Access 97, e.g. AllForms collection, OpenReport in dialog mode, Split() or
InStrRev() functions, Printers collection, Decimal field type, JET 4 DDL,
some subquery constructs, records wider than 2k, Addnew for list boxes, etc,
etc.

 

[Evi]

Definitely convert a copy first and see if all the forms and reports and
querys run. Do a Compile before you convert just in case there is something
nasty left.

Evi