CONVERSION FROM ACCESS97 TO ACCESS2002

1) POUUTIL needs to be converted to 2002, 2002 programs cannot connect to libraries in Access97 version.  However 2000 can connect to Access97 libraires.

2) The vertical bar | in a query doesn’t seem to be supported. Using the INSTR function and using a criteria of > 0 can replace this.

3) Cannot use the command

    Set MyDb = DBEngine.Workspaces(0).Databases(0)

    To open a the local database.  Instead use the following:

    Set MyDb = CurrentDB

 4) Running into a problem with downloading the CF file config strings, cuts off at 200 characters.