I am sure you can use the disconnected feature of ADO.NET implemented using Datasets.

You can store all the data in the dataset and then in the end post all the...

Starrting with SQL Server 2000. It is possible to have more than one instance of sql server on a single windows server. These instances are isolated from one another, they...

I am sure you are trying this with SQl server 2000.

The connecting string should be

sConn = "Provider=sqloledb;Data Source=myServerName\myInstanceName;Initial Catalog=myDatabaseName;User Id=myUsername;Password=myPassword"

You can create a UDF for returning the third column. The UDF would accept claimID  as the parameter and would loop to create a string separated with commans.

e.g. SELECT Claim.Claim_ID,Cust_Name,Entry_Date,UDF(CLaimID)

   group...

While using wild chaaracters one needs to use the escape characters while using symbols like % and [. Look in BOL for the syntax for I am not recollecting it...

The Problem lies in how sql server handles locking mechanism. If sql server feels that placing 4 row locks would be more resource intensive than placing a single page lock...

One major difference is the way date is handled, MS-Access uses # for dates while SQl server uses single quotes.

One more option I can remember is using the charAt function.

I guess you can use linked table features provided in access database. this would ensure that you have the data from the sql...

You can use scope_identity for finding the last Id that was inserted.Also look in BOL for difference between @@identity and @@scope_identity

Normally it's best to autogenerate the primary keys use identity columns if you are not in any way allowing users of your application to use them directly. You can define...