Problem updateing an Access database
in [Visual Basic]
|
Prev: Array Problem
Next: Set backcolor in a StatusBar ?
From: Tony A. on 29 Dec 2009 11:03 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
From: Bob Butler on 29 Dec 2009 11:22 "Tony A." <TonyA(a)discussions.microsoft.com> wrote in message news:9312E6DA-8053-4D57-934E-9257A8464831(a)microsoft.com... >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. Sounds like maybe the SQL table is configured to allow null values in one or more fields and the access table is not.
From: Jeff Johnson on 29 Dec 2009 15:41 "Tony A." <TonyA(a)discussions.microsoft.com> wrote in message news:9312E6DA-8053-4D57-934E-9257A8464831(a)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?
From: Bob Butler on 29 Dec 2009 15:51 "Jeff Johnson" <i.get(a)enough.spam> wrote in message news:OA1bHdMiKHA.4912(a)TK2MSFTNGP02.phx.gbl... > "Tony A." <TonyA(a)discussions.microsoft.com> wrote in message > news:9312E6DA-8053-4D57-934E-9257A8464831(a)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? 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.
From: Ralph on 29 Dec 2009 16:33
"Bob Butler" <noway(a)nospam.ever> wrote in message news:OpNNyjMiKHA.4220(a)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. |