UPDATE works INSERT does not - no errors!

  • Thread starter Thread starter tdi1686
  • Start date Start date
T

tdi1686

(Using a jet 4 oledb connection to an access 2000 db)

I have a site that is programmed using Dreamweaver MX ASP.NET VB. I have
several pages that update, and insert stuff into the access DB.

On my dev machine (2000 Server, .NET 1.1, MDAC 2.8) all the pages work fine,
however when I upload the pages and Db to my hosting provider
www.discountasp.net (Server 2003 .NET 1.1, MDAC ?) only the pages that
INSERT work. The pages that UPDATE dont generate any errors, but the data
remains unchanged.

I thought it was a permissions issue, but seeing as I can INSERT, surely I
can UPDATE???

This is driving me bananas, help!

tdi1686
 
I would look at permissions.

Make sure that the asp.net user accunt have file
permission to the database this should be done under the
securities tab..check this first. This is my best guess
 
Hi there,

check out for page postback issues. Can you also post the
code which you are using.

Kaustav Neogy
 
Back
Top