Re: Developing in Access 2003 for Access 97 users

Dean, if you have Access 97 as well as 2003, I would agree with Lyle that it
would be better to use 97 to develop this database. I actually did a small
one earlier this year using 2003 and converting back at the end: if I had
that time again, I would do the whole thing in A97.

It kinda depends what functionality you use, but avoid stuff like:
- Conditional Formatting
- the Undo event of the form.
- OpenArgs for OpenReport.
- VBA functions such as Replace() and Split().
- ADO-specific code (especially DDL)

If you do convert back, decompile first. Avoid any references other than
VBA, Access and DAO. After conversion to A97, you will still need to change
your DAO reference to 3.51. (A2003 doesn't make that change for you.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Lyle Fairfield" <lylefairfield@xxxxxxx> wrote in message
news:1135123457.218336.16840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> DeanL wrote:
>> I know you can convert a database from Access 2003 to 97 easily but is
>> there anything that I should avoid doing in Access 2003 that might make
>> my database incompatible with Access 97?
>
> Starting.


.

Relevant Pages

  • Re: Developing in Access 2003 for Access 97 users
    ... > Not the Undo METHOD, ... to A97, anyway, so those are rather irrelevant to the basic ADO ... The silent discard is ... > discard before converting back to any previous version, ...
    (comp.databases.ms-access)
  • Re: A few more A97 vs A2000 questions
    ... version and converting to Access 97. ... A SwB created in A97 has no ... >>> machines and can't resolve the problem so far. ... >>> incompatibility between the first set and the rest. ...
    (microsoft.public.access.conversion)
  • Re: Conversion Problems
    ... A2K3 now and I open a database created in A97 and convert, ... >libraries available to them (although sometimes you have ... >references when converting. ...
    (microsoft.public.access.gettingstarted)
  • Re: Access 95 Report Corrupt
    ... Try converting to A97 file-format first. ... In A97, change the Library to DAO 3.51 Object Library. ... converted file, fix any Compile errors and make sure that no Compile errors ... > We have a database that was created in Access 95. ...
    (microsoft.public.access.gettingstarted)
  • Re: Where to find nanofarad capacitors in the US?
    ... Are they common? ... Even converting to pF/uF I still can't find a match. ... Its use is encouraged in order to avoid using the decimal point in component ...
    (sci.electronics.basics)