473,396 Members | 1,676 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

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
12 2009
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
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
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
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
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
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: David | last post by:
I do some website design here and there occasionally for a few clients and I've got a new one that wants a database with their website that will display pricelists displayed for their products and...
13
by: LRW | last post by:
Having a problem getting a onSubmit function to work, to where it popsup a confirmation depending on which radiobutton is selected. Here's what I have: function checkdel() { if...
7
by: Novice Computer User | last post by:
Hi. Can somebody PLEASE help. I have spent hours on this.. but I am a total novice and can't seem to figure it out. Here is a .php script. Right now, the minimum amount of time (i.e. duration)...
2
by: dennist685 | last post by:
Can't open Northwind I remembered doing walkthrough using Northwind. However it wasn't an http project but a file project using the development server. Northwind allowed me to add, edit and...
2
by: jjbnfo | last post by:
Hi all, I'm trying to edit VBA code in my mdb file for a form. Basically, I want to delete and comment out some lines of code. (I'm quite good at VBA, so I don't need help there). I'm...
1
by: mgworek | last post by:
access xp, sql server 2000. Just converted entire database to sql and keeping access front end. Problem is only with one table. inserting a new record works fine. If I go back to that record...
2
by: tomtom99 | last post by:
Hi guys! My first post here of many here so go easy one me :) Skip this paragraph for my question but just to give you some background info as to enlighten you in my situation I'm 19 years old...
8
by: chromis | last post by:
Hi, I'm writing a contacts section for a cms on a website, I've decided to write the section in OO code. So far I have my Contacts object and a page structure I would use for a procedural site. ...
1
by: chromis | last post by:
Hi, I'm having trouble fully implementing the edit section of a contact admin system, so far I have written the following: - Bean (Contact.cfc) - Data Access object (ContactDAO.cfc) - Gateway...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.