Can't edit, delete or add row in an Access database in a website 2

Guest · Nov 24, 2005

Can't edit, delete or add row in an Access database in a website 2003

When I implement a walkthrough using Northwind I have no trouble doing this.

Also, in a windowsforms project I have no problem editing, adding or
deleting rows.

But in webforms the smarttags don't offer the options.

Can anybody help?

dennist685

Patrick.O.Ige · Nov 24, 2005

dennist685 what are you trying to do exactly..
How are you trying to do this on your page etc..
Elaborate more
Patrick

Guest · Nov 24, 2005

After I read your reply Ireconfigured my AccessDataSource I also clicked
advance and specify generating insert, delete, edit.

Edit worked; Delete worked.

However, if I try to insert, I get the following error:
The entry calls for a string. There are two fields - an autoincrementing
ID, which of course doesn't show, and the name of the topicissuer. I typed
in vvv, just for a test.

Server Error in '/Access' Application
--------------------------------------------------------------------------------

You tried to assign the Null value to a variable that is not a Variant data
type.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: You tried to assign the
Null value to a variable that is not a Variant data type.

Source Error:

An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.

Stack Trace:

[OleDbException (0x80004005): You tried to assign the Null value to a
variable that is not a Variant data type.]

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
+194
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand
command, DataSourceOperation operation) +392
System.Web.UI.WebControls.SqlDataSourceView.ExecuteInsert(IDictionary
values) +405
System.Web.UI.DataSourceView.Insert(IDictionary values,
DataSourceViewOperationCallback callback) +68
System.Web.UI.WebControls.DetailsView.HandleInsert(String commandArg,
Boolean causesValidation) +391
System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean
causesValidation, String validationGroup) +609
System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source,
EventArgs e) +87
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source,
EventArgs e) +109
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +86
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String
eventArgument) +153

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919

Steven Cheng[MSFT] · Nov 24, 2005

Hey Dennist,

Would you provide us the table's structure and the asp.net page which cause
the error so that we can have a look or test on local side? I think there
may have some config setting problem in the aspx page.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Guest · Nov 26, 2005

Steven,

I sent the application as a zip file. Please excuse my rudeness in not
mentioning your name in the reply in which the attachment was sent. I may hav
e sent it twice.

I hope a 51.3kb zip file is acceptable as an attachment through outlook
express.

dennist685

Steven Cheng[MSFT] · Nov 28, 2005

Thanks for your respones Dennist,

I've got the zip attachement and will perform some tests.
Also, if you feel convenient, we can continue to discuss in one of all the
three threads you've opened on this issue.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
--------------------
| From: "dennist685" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
| Subject: Re: Can't edit, delete or add row in an Access database in a
websi
| Date: Sat, 26 Nov 2005 08:12:55 +0200
| Lines: 1194
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
| X-RFC2646: Format=Flowed; Original
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: 192.117.113.41
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:361030
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
|
| | > Hey Dennist,
| >
| > Would you provide us the table's structure and the asp.net page which
| > cause
| > the error so that we can have a look or test on local side? I think
there
| > may have some config setting problem in the aspx page.
| >
| > Thanks,
| >
| > Steven Cheng
| > Microsoft Online Support
| >
| > Get Secure! www.microsoft.com/security
| > (This posting is provided "AS IS", with no warranties, and confers no
| > rights.)
| >
|
|
|

Guest · Nov 30, 2005

Steven,

I've been in the hospital a few days. Only read your reply just now. I
won't be able to download your file until I get home. Then, give me a day to
digest it.

Thanks for all your work.

dennist685

Steven Cheng[MSFT] · Nov 30, 2005

I'm sorry to hear that Dennist.

Have a good rest and don't worry about this problem. I'll keep holding this
thread and when you need any further assistance, please feel free to post
here.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Thread-Topic: Can't edit, delete or add row in an Access database in a
websi
| thread-index: AcX1cVlFi5B5HQ57S9C+QQhbPVKe6Q==
| X-WBNR-Posting-Host: 192.117.113.41
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<TBWG11#[email protected]>
| Subject: Re: Can't edit, delete or add row in an Access database in a
websi
| Date: Tue, 29 Nov 2005 21:46:02 -0800
| Lines: 9
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:361695
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven,
|
| I've been in the hospital a few days. Only read your reply just now. I
| won't be able to download your file until I get home. Then, give me a
day to
| digest it.
|
| Thanks for all your work.
|
| dennist685
|

Guest · Nov 30, 2005

I ran up against a terrible problem with Access. I'm going to submit it to
its proper place, Access Security. In a couple of hours, or whenever after
that which is convenient for you, please have a look there.

dennist685

Steven Cheng[MSFT] · Dec 1, 2005

Guest · Dec 3, 2005

Steven,

I tried to test your project. However, I'm doing something wrong. I loaded
it, and in solution explorer, all the files are there. However when I hit
cntl+F5, I get a web page with a directory listing, showing each of the
files. Then I tried to build the solution.

I get a dialog box that says, save file as ..

The save in says Access(3)

and the file name is Access(3).

I did so and the build succeeded.

However when I hit cntl+f5, and got the directory listing again.

As far as your analysis goes, I can see the problem. However, isn't this a
bug in asp.net 2.0 that should be reported to Microsoft? It seems rather
serious.

dennist685

Guest · Dec 3, 2005

Steven

An associated problem involves the server. Even though I have the project
in inetpub/wwwroot/Access2 - I thought renaming it might change the result
but it didn't - I still get the development server - Version Information:
ASP.NET Development Server 8.0.0.0

This is a serious problem. How does one get an Access database on the web,
using one's own computer.

I realize this is a different thread. If you wish I'll repeat this post in
a new thread.

dennist685

Steven Cheng[MSFT] · Dec 5, 2005

Hi Dennist,

OK. I think it'll be better to start a new thread which can make it problem
clear and more convenient for discussing.

Thanks,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

--------------------
| Thread-Topic: Can't edit, delete or add row in an Access database in a
websi
| thread-index: AcX32P8zOaBEzhl2SMacOH4utOEo4w==
| X-WBNR-Posting-Host: 80.179.14.44
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <[email protected]>
| References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
<TBWG11#[email protected]>
<[email protected]>
<[email protected]>
| Subject: Re: Can't edit, delete or add row in an Access database in a
websi
| Date: Fri, 2 Dec 2005 23:13:01 -0800
| Lines: 14
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:362484
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| Steven
|
| An associated problem involves the server. Even though I have the
project
| in inetpub/wwwroot/Access2 - I thought renaming it might change the
result
| but it didn't - I still get the development server - Version Information:
| ASP.NET Development Server 8.0.0.0
|
| This is a serious problem. How does one get an Access database on the
web,
| using one's own computer.
|
| I realize this is a different thread. If you wish I'll repeat this post
in
| a new thread.
|
| dennist685
|

Can't execute php to delete multiple rows in database	3	May 14, 2023
Hide Edit or Delete Buttons per Row in a GridView	3	Nov 24, 2006
cannot delete or edit inserted records ( via detailsview) in gridview	1	Jul 31, 2006
Dynamically add row to a table	3	Aug 16, 2007
Insert Row in GridView using SqlDataSource and update to database ?	5	Nov 16, 2007
Edit Access Database Online	2	Jul 20, 2004
A better way to add a row to a gridview	0	May 1, 2007
How to edit selected row of GridView in a DetailsView?	2	Aug 31, 2007

Can't edit, delete or add row in an Access database in a website 2

Guest

Patrick.O.Ige

Guest

Steven Cheng[MSFT]

Guest

Steven Cheng[MSFT]

Guest

Steven Cheng[MSFT]

Guest

Steven Cheng[MSFT]

Guest

Guest

Steven Cheng[MSFT]

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads