By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,302 Members | 3,621 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,302 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 24 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
dennist685 what are you trying to do exactly..
How are you trying to do this on your page etc..
Elaborate more
Patrick

"dennist685" <de********@newsgroup.nospam> wrote in message
news:8C**********************************@microsof t.com...
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

Nov 24 '05 #2

P: n/a
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.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
+194
System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
System.Web.UI.WebControls.SqlDataSourceView.Execut eDbCommand(DbCommand
command, DataSourceOperation operation) +392
System.Web.UI.WebControls.SqlDataSourceView.Execut eInsert(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.OnBubbleEven t(Object source,
EventArgs e) +87
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.DetailsViewRow.OnBubbleE vent(Object source,
EventArgs e) +109
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(Com mandEventArgs e) +86
System.Web.UI.WebControls.LinkButton.RaisePostBack Event(String
eventArgument) +153

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


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42
Nov 24 '05 #3

P: n/a
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.)

Nov 24 '05 #4

P: n/a
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
Nov 26 '05 #5

P: n/a
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" <de********@nospam.gmail.com>
| References: <8C**********************************@microsoft.co m>
<ui**************@tk2msftngp13.phx.gbl>
<FA**********************************@microsoft.co m>
<Qc*************@TK2MSFTNGXA02.phx.gbl>
| 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: <u2**************@TK2MSFTNGP14.phx.gbl>
| Newsgroups: microsoft.public.dotnet.framework.aspnet
| NNTP-Posting-Host: 192.117.113.41
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP14.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl
microsoft.public.dotnet.framework.aspnet:361030
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
|
| "Steven Cheng[MSFT]" <st*****@online.microsoft.com> wrote in message
| news:Qc*************@TK2MSFTNGXA02.phx.gbl...
| > 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.)
| >
|
|
|

Nov 28 '05 #6

P: n/a
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
Nov 30 '05 #7

P: n/a
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==?=" <de********@newsgroup.nospam>
| References: <8C**********************************@microsoft.co m>
<ui**************@tk2msftngp13.phx.gbl>
<FA**********************************@microsoft.co m>
<Qc*************@TK2MSFTNGXA02.phx.gbl>
<u2**************@TK2MSFTNGP14.phx.gbl>
<TB**************@TK2MSFTNGXA02.phx.gbl>
| 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: <EB**********************************@microsoft.co m>
| 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
|

Nov 30 '05 #8

P: n/a
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]" wrote:
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==?=" <de********@newsgroup.nospam>
| References: <8C**********************************@microsoft.co m>
<ui**************@tk2msftngp13.phx.gbl>
<FA**********************************@microsoft.co m>
<Qc*************@TK2MSFTNGXA02.phx.gbl>
<u2**************@TK2MSFTNGP14.phx.gbl>
<TB**************@TK2MSFTNGXA02.phx.gbl>
| 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: <EB**********************************@microsoft.co m>
| 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
|

Nov 30 '05 #9

P: n/a
Thanks for your followup Dennist,

I'll continue to followup in your new threads.

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: AcX1klCuYnskiMPDT261QLSCK4boZg==
| X-WBNR-Posting-Host: 85.64.135.196
| From: "=?Utf-8?B?ZGVubmlzdDY4NQ==?=" <de********@newsgroup.nospam>
| References: <8C**********************************@microsoft.co m>
<ui**************@tk2msftngp13.phx.gbl>
<FA**********************************@microsoft.co m>
<Qc*************@TK2MSFTNGXA02.phx.gbl>
<u2**************@TK2MSFTNGP14.phx.gbl>
<TB**************@TK2MSFTNGXA02.phx.gbl>
<EB**********************************@microsoft.co m>
<ll**************@TK2MSFTNGXA02.phx.gbl>
| Subject: Re: Can't edit, delete or add row in an Access database in a
websi
| Date: Wed, 30 Nov 2005 01:42:02 -0800
| Lines: 71
| Message-ID: <90**********************************@microsoft.co m>
| 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:361740
| X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
|
| 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]" wrote:
|
| > 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==?=" <de********@newsgroup.nospam>
| > | References: <8C**********************************@microsoft.co m>
| > <ui**************@tk2msftngp13.phx.gbl>
| > <FA**********************************@microsoft.co m>
| > <Qc*************@TK2MSFTNGXA02.phx.gbl>
| > <u2**************@TK2MSFTNGP14.phx.gbl>
| > <TB**************@TK2MSFTNGXA02.phx.gbl>
| > | 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: <EB**********************************@microsoft.co m>
| > | 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
| > |
| >
| >
|

Dec 1 '05 #10

P: n/a
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
Dec 3 '05 #11

P: n/a
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
Dec 3 '05 #12

P: n/a
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==?=" <de********@newsgroup.nospam>
| References: <8C**********************************@microsoft.co m>
<ui**************@tk2msftngp13.phx.gbl>
<FA**********************************@microsoft.co m>
<Qc*************@TK2MSFTNGXA02.phx.gbl>
<u2**************@TK2MSFTNGP14.phx.gbl>
<TB**************@TK2MSFTNGXA02.phx.gbl>
<EB**********************************@microsoft.co m>
<ll**************@TK2MSFTNGXA02.phx.gbl>
| 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: <8C**********************************@microsoft.co m>
| 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!TK2MSFT NGXA03.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
|

Dec 5 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.