UPDATE works INSERT does not - no errors!

[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

[Tyrone]

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

-----Original Message-----
(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 haveseveral 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 providerwww.discountasp.net (Server 2003 .NET 1.1, MDAC ?) only the pages thatINSERT work. The pages that UPDATE dont generate any errors, but the dataremains unchanged.

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

This is driving me bananas, help!

tdi1686
.

[Kaustav Neogy]

Hi there,

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

Kaustav Neogy

-----Original Message-----
(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 haveseveral 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 providerwww.discountasp.net (Server 2003 .NET 1.1, MDAC ?) only the pages thatINSERT work. The pages that UPDATE dont generate any errors, but the dataremains unchanged.

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

This is driving me bananas, help!

tdi1686
.