Okay, I am using MS Access as backend righ-now, there is a change that i may have to change it to SQL Server after some time, so can anyone let me know which codepart I have to change while changing DB, OR how to write DB independent ASP code.

SQL Server is an enterprize data store, Access is not. You are better off going to SQL sooner than later for many many reasons, scaleability being the number one.

;;;which codepart I have to change while changing DB
Your connection string is all you need to change. It should look something like:
Provider=SQLOLEDB.1; Password=aPassword; Persist Security Info=True; User ID=aUserName; Initial Catalog=aDBName; Data Source=pcName;

;;;how to write DB independent ASP code
ASP code is DB independent

Moving from Access to SQL is very easy. When you get SQL installed look at the DTS tool. There are differences in datatypes and a few other things to be aware of.

Wind is your friend
Matt

Right now i am using Recordset.AddNew method to Add new record, I heard that It won't work if i change DB, so better to write objConnection.Execute "inset into..", is it true? Can you focus on this?
Thanks in Advance.

I dont use this method so im not sure, what do I do in every page I need a database connection:
<% OPTION EXPLICIT %>


<% Set Conn = server.createobject("ADODB.Connection")
     conn.open(GetConnectionString)
     'an insert
     sql = "INSERT INTO..."
     conn.execute(sql)
     'an select
     sql = "SELECT..."
     set rsName = conn.execute(sql)
%>


In you global.asp file place all your constants etc:
   const IUSER = "un"
   const pWord = "pw"
   const DBNAME = "db"
   const DBSERVER = "aPcName"

In your functions.asp place all your functions including your connection string:
  GetConnectionString = "Provider=SQLOLEDB; Password=" & PASS & "; Persist Security Info=True; User ID=" & IUSER & ";Initial Catalog=" & DBNAME & "; Data Source=" & DBSERVER
  End Function

Now all you need to do when chnaging DBs is change one line in your functions.asp file





Wind is your friend
Matt