More FrontPage/Access problems

[Dave Akers]

We are trying to to run a Frontpage Designed site that
uses a Access d-base to allow students to search for
scholarships on a local level. Here is the problem:

At first when the site went to post search results from
the database we getting this error message:

Microsoft VBScript runtime error '800a005e'
Invalid use of Null: 'Replace'
/_fpclass/fpdblib.inc, line 33

we went in and changed all the fields in the database
from "memo" to "text" and the error went away but now we
can only display up to 255 characters of text, if we
change the one field that is needed to show large amounts
of text to "memo" format we get the error above again.

We even made sure that all enteries in that field contain
text with no change.

Can any one help?

www.moversonline.org

 

[Kathleen Anderson [MVP - FP]]

Dave:
Do you have a backup copy of the database stored on your hard drive
somewhere, with the datatype equal to Memo? If so, there's a couple of
things I would try, in this order:
Delete the global.asa and the database from your web, and then reimport the
database from your hard drive and let FP create a new global.asa. Then, try
creating a new query page and see if it works.