My access database keeps failing - if I update it manually I often get an
error message on saving the file: "Internal Error: Negative content length
for file upload" this then corrupts the database and I get an "Unrecognised
database format" so have to go back to my back up copy. Very frustrating,
Any ideas? Thanks.

Never update manually by accessing the database thru FP, always export the database to your desktop,
then make changes, then re-import into your web.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


"Raymondo" <(E-Mail Removed)> wrote in message
news:5DC2DC14-47D6-4EDB-99EF-(E-Mail Removed)...
> My access database keeps failing - if I update it manually I often get an
> error message on saving the file: "Internal Error: Negative content length
> for file upload" this then corrupts the database and I get an "Unrecognised
> database format" so have to go back to my back up copy. Very frustrating,
> Any ideas? Thanks.

Ok, It's a lesson learned!

However, did it that way as my FP database editor now shows a: Syntax error
in UPDATE statement.
Number: -2147217900 (0x80040E14) I have put Timestamp in[] and looked for
other unacceptable names. This is since I changed the connection to a new
database connection. Any ideas?

"Thomas A. Rowe" wrote:

> Never update manually by accessing the database thru FP, always export the database to your desktop,
> then make changes, then re-import into your web.
>
> --
> ==============================================
> Thomas A. Rowe
> Microsoft MVP - FrontPage
> ==============================================
> Agents Real Estate Listing Network
> http://www.NReal.com
> ==============================================
>
>
> "Raymondo" <(E-Mail Removed)> wrote in message
> news:5DC2DC14-47D6-4EDB-99EF-(E-Mail Removed)...
> > My access database keeps failing - if I update it manually I often get an
> > error message on saving the file: "Internal Error: Negative content length
> > for file upload" this then corrupts the database and I get an "Unrecognised
> > database format" so have to go back to my back up copy. Very frustrating,
> > Any ideas? Thanks.
>
>
>

Timestamp and Date are reserve words in Access Jet engine, so you will need to rename the fields.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================


"Raymondo" <(E-Mail Removed)> wrote in message
news:20B8C7FA-F0BC-4118-BCEB-(E-Mail Removed)...
> Ok, It's a lesson learned!
>
> However, did it that way as my FP database editor now shows a: Syntax error
> in UPDATE statement.
> Number: -2147217900 (0x80040E14) I have put Timestamp in[] and looked for
> other unacceptable names. This is since I changed the connection to a new
> database connection. Any ideas?
>
> "Thomas A. Rowe" wrote:
>
>> Never update manually by accessing the database thru FP, always export the database to your
>> desktop,
>> then make changes, then re-import into your web.
>>
>> --
>> ==============================================
>> Thomas A. Rowe
>> Microsoft MVP - FrontPage
>> ==============================================
>> Agents Real Estate Listing Network
>> http://www.NReal.com
>> ==============================================
>>
>>
>> "Raymondo" <(E-Mail Removed)> wrote in message
>> news:5DC2DC14-47D6-4EDB-99EF-(E-Mail Removed)...
>> > My access database keeps failing - if I update it manually I often get an
>> > error message on saving the file: "Internal Error: Negative content length
>> > for file upload" this then corrupts the database and I get an "Unrecognised
>> > database format" so have to go back to my back up copy. Very frustrating,
>> > Any ideas? Thanks.
>>
>>
>>