Browse by Tags

Related Posts

  • 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
  • Re: Update field OnClick after record update

    The "Completed" field is a boolean yes/no field. I don't show the check box on the entry form, but want to check it as it will allow me to select records based on that check box and it is visible, but not editable, to the user in a gridview of all the records. Currently I have a select...
    Posted to Access Databases and AccessDataSource Control (Forum) by EFoo on 04-15-2008, 12:00 AM
    Filed under: update, vb.net, .Net 2.0, access, Access Database, access oledb, accessdatabase, accessdatasource, ASP.NET 2.0, .ASPX
  • CLR access to Access Db

    Hi all, I'm quite desperate. Since two days I'm trying to get data from a access db through a server based clr (vb.net) with an oledb provider. The connection string is: "Provider=Microsoft.Jet.OLEDB.4.0;user id=developer;Password=bla ;Data source=C:\test\test.mdb ;Jet OLEDB:System database...
    Posted to Access Databases and AccessDataSource Control (Forum) by PCM_IT on 08-28-2007, 12:00 AM
    Filed under: vb.net, access, Access Database - FileDSN in ASP.NET 2.0, Access database query string, accessdatabase, AccessDataSource INSERT problem, data access, database, Microsoft Access Database Delete, mdb, OLEDB - Relative Connection string, 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
  • DSNless connection to MS Access DB

    Hi all, I am new to asp.net and have been having some issues - can anyone help? I have webspace set up with .net framework but no sql or mysql DB, so i am trying to use a dsnless connection to a ms access db instead. The example I am using worked fine locally but now that i have uploaded it there is...
    Posted to Access Databases and AccessDataSource Control (Forum) by french_duke on 03-12-2007, 12:00 AM
    Filed under: vb.net, access, asp.net, dsnless
  • Re: How can I connect to an Access DB from a webfarm?

    FYI ~ I have set all 3 servers up with the same username/password (used by IIS). The user account on Server3 has full control to the folder and file. I did create a page on Web1 and Web2 that accesses an image in the same directory on Server3 (for display on a web page), and the image displays fine....
    Posted to Access Databases and AccessDataSource Control (Forum) by Knoter on 02-21-2007, 12:00 AM
    Filed under: thank you, vb.net, access, AccessDataSource INSERT problem, database
  • How can I connect to an Access DB from a webfarm?

    Scenario: I've a WebFarm with 2 web servers which are NLBs (network load balanced). Web1 and Web2 ; they are not part of a domain. I have a third server, Server3 , which is part of a domain and on the same physical network, and it has an MSAccess database which is used on the external webfarm as well...
    Posted to Access Databases and AccessDataSource Control (Forum) by Knoter on 02-21-2007, 12:00 AM
    Filed under: Odbc, thank you, vb.net, access, Access database query string, database
  • extracting and displaying access date in format mmmm yyyy

    Hi Folks, Appreciate any help with this one. I am looking to do a query that will take the last 6 distinct months and years from a database and display them by the latest month year first. My sql query is: select distinctrow top 6 releasedate, month(releasedate), format(month(releasedate),'MMMM'), year...
    Posted to Access Databases and AccessDataSource Control (Forum) by turk_350 on 01-08-2007, 12:00 AM
    Filed under: repeater, vb.net, access, date, dates, format, mmmm
  • AdventureWorks Onlne Application

    Does any body knows active running appplication making use of all AdventureWorks Database
    Posted to Free For All (Forum) by Amolkumar on 02-22-2007, 12:00 AM
    Filed under: Odbc, read, relational tables related insertion, repeater, thank you, vb.net, access, Access database query string, AccessDataSource INSERT problem, AdventureWorks, ajax, autocompleteextender, c#, concurrency, Connection String to Database hosted on GoDaddy, database, date, dates, format, mmmm, webservice, mdb, asmx
Page 1 of 1 (9 items)
Microsoft Communities