Corrupt database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
==============================================
 
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?
 
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...
 
Back
Top