Browse by Tags

Related Posts

  • Delete database record on page exit if blank

    I have to develope a form which has a form number on it which is based on an auto-number in an Access database where the form details are to be stored. I know how to query the database for the next number although this would not be very useful if 2 forms were being created at the same time by different...
    Posted to Web Forms (Forum) by scottc1988 on 01-13-2009, 12:00 AM
    Filed under: Access, access DB, ASP .net 3.0, Database, database webform, Databases, event, event controls, event handlers, event handling, Event webform Property, eventhandler, events, Event's don't fire, events initiation, EXIT, webb form, webform, .ASPX, .aspx page, .aspx.vb
  • Insert query being fired twice

    hi every one i am having a strange problem - while trying to insert values in access database 2 rows are being inserted instead of 1. the code being used is pasted below. please help. Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click Dim sql As String...
    Posted to Access Databases and AccessDataSource Control (Forum) by abhishekbrowne on 07-07-2008, 12:00 AM
    Filed under: access, Access database query string, access oledb, asp.net, ASP.NET 2.0, database, Insert into Access Database, insert method, .ASPX, .aspx.vb, .Net 2.0
  • Inserting into two tables at the same time with the same ID

    Hi, I am not sure if this is the right place to ask this but I have been searching the web and have yet to come across a suitable example. I am new to .NET but have had previous experience with ASP Anyway here goes, I have two tables in an Access database, named Colours and Horse, Horse (ID(AutoNumber...
    Posted to Access Databases and AccessDataSource Control (Forum) by richardh09 on 05-30-2008, 12:00 AM
    Filed under: Primary Key, record, Scope Identity, sql, SQL Query, vb.net, access, Access database query string, access oledb, asp.net, ASP.NET 2.0, data access, database, Insert into Access Database, insert method, SELECT command, .aspx.vb, .Net 2.0, Access Database
  • Handling Exceptions

    i am trying to trigger the "record already exists" exception. This is the message i get: System.Data.OleDb.OleDbException: The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the...
    Posted to Access Databases and AccessDataSource Control (Forum) by m_coomer146 on 12-06-2007, 12:00 AM
    Filed under: access, Access database query string, AccessDataSource SQL, asp.net, ASP.NET 2.0, data access, errors, Insert into Access Database, Insert into SQL, .aspx.vb, exceptions, .Net 2.0, Access Database
  • Re: Record(s) cannot be read; no read permission on 'MSysObjects'.

    If you people are using AccessDataSource and having error " Record(s) cannot be read; no read permission on [table] ", first step is to open up the MDB file and assign full rights to Admin user for each & every table either its system or hidden table. if you want to see all system &...
    Posted to Access Databases and AccessDataSource Control (Forum) by moizdhanji on 08-08-2007, 12:00 AM
    Filed under: Odbc, OLEDB - Relative Connection string, vb.net, .Net 2.0, access, Access Database, Access Database - FileDSN in ASP.NET 2.0, Access database query string, accessdatabase, AccessDataSource INSERT problem, asp.net, ASP.NET 2.0, c#, data access, database, Microsoft Access Database Delete, .aspx.vb, mdb
Page 1 of 1 (5 items)