Corrupt database

R

Raymondo

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.
 
T

Thomas A. Rowe

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
==============================================
 
R

Raymondo

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?
 
T

Thomas A. Rowe

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 said:
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 said:
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
==============================================
Click to expand...
Click to expand...
 
Top