Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Problem updateing an Access database

0 views
Skip to first unread message

Tony A.

unread,
Dec 29, 2009, 11:03:01 AM12/29/09
to
I developed an ASP application using Access as the database. I'm using a
Gridview control to display the data. When the user selects Edit the
dropdeownlist appears with valid options. When Update is clicked an error
appears indicating the value for one or more columns is missing.

If I use the same application with SQL Server Express as the database, there
is no error, the update happens.

Any suggestion on why SQL Server Express works and Access does not? I use
the Access Provider with the Access database and SQLConnection with SQL
Server Express.

--
Tony

Bob Butler

unread,
Dec 29, 2009, 11:22:25 AM12/29/09
to

"Tony A." <To...@discussions.microsoft.com> wrote in message
news:9312E6DA-8053-4D57...@microsoft.com...

Sounds like maybe the SQL table is configured to allow null values in one or
more fields and the access table is not.

Jeff Johnson

unread,
Dec 29, 2009, 3:41:18 PM12/29/09
to
"Tony A." <To...@discussions.microsoft.com> wrote in message
news:9312E6DA-8053-4D57...@microsoft.com...

> Any suggestion on why SQL Server Express works and Access does not? I use


> the Access Provider with the Access database and SQLConnection with SQL
> Server Express.

"SqlConnection"? Are you sure this is a VB6 question?


Bob Butler

unread,
Dec 29, 2009, 3:51:55 PM12/29/09
to

"Jeff Johnson" <i....@enough.spam> wrote in message
news:OA1bHdMi...@TK2MSFTNGP02.phx.gbl...

It starts off saying it's an ASP application; the comment about displaying
data in a GridView sounded to me like maybe it's actually ASP.Net but I was
figuring that the problem really wasn't language-related anyway. It
probably should be reposted in either an ASP group or a dotnet group for
best results.

It's bad enough that people use VB to refer to B#. If they start calling
ASP.Net just ASP it'll add even more confusion.

Ralph

unread,
Dec 29, 2009, 4:33:58 PM12/29/09
to

"Bob Butler" <no...@nospam.ever> wrote in message
news:OpNNyjMi...@TK2MSFTNGP05.phx.gbl...

>
> It's bad enough that people use VB to refer to B#. If they start calling
> ASP.Net just ASP it'll add even more confusion.
>

Add ADO.Net and ADO to the pile.


Cor Ligthert[MVP]

unread,
Dec 30, 2009, 7:15:40 AM12/30/09
to
Jeff,

In my idea you know that it is almost impossible that it can be a VB6
application.
Or it should be somebody trying to bring again the very quick withdrawn
product vb6 web class to life.

http://www.avdf.com/oct98/art_id003.html

It ended that this became actually ASP.Net in 2002

(The GridView is an Asp.Net control from Net versions later than 1.1)

I can answer this question here, but I think the OP is better of in an
ASP.Net forum or in an Asp.Net newsgroup.

Cor


"Jeff Johnson" <i....@enough.spam> wrote in message
news:OA1bHdMi...@TK2MSFTNGP02.phx.gbl...

Paul Clement

unread,
Dec 30, 2009, 1:48:52 PM12/30/09
to
On Tue, 29 Dec 2009 08:03:01 -0800, Tony A. <To...@discussions.microsoft.com> wrote:

� I developed an ASP application using Access as the database. I'm using a

I would suspect that you have columns in your Access table that are require values but are not
included in the INSERT statement or, values for columns are not being supplied in the INSERT
statement.

Since this is a .NET web app I would re-post your question (with exception message) to the following
ASP.NET forum:

http://forums.asp.net/85.aspx


Paul
~~~~
Microsoft MVP (Visual Basic)

0 new messages