We have got a client that administers their website through a admin section that we developed some two years ago now, there have been updates to this, but this section is pretty much unchanged. The client adds press releases on a regular basis, using these templates, they enter text in the same way i am here, with this forum. Occasionally they require a press release to be created with special formatting that we produce using HTML, recently these HTML formatted updates have been failing to be added to the database and we get a failed to insert error on the page.
When we add the same HTML formatted press release to our test server, that uses the same code, and the same database the press release is added.
The database is an access 97 database and the main field in the database for the release is a memo field. I've looked at the specs for an access database and the data being added is within the limits of the database fields.
The forms still work when a normal press release is added using the admin forms.
Does anyone have any idea why this is failing, currently i have got no debugging code available to provide any more detail as to the error.
When we add the same HTML formatted press release to our test server, that uses the same code, and the same database the press release is added.
The database is an access 97 database and the main field in the database for the release is a memo field. I've looked at the specs for an access database and the data being added is within the limits of the database fields.
The forms still work when a normal press release is added using the admin forms.
Does anyone have any idea why this is failing, currently i have got no debugging code available to provide any more detail as to the error.