Sample access db connection string

<%
' Set the database file path and name
db_file = "h:\root\home\fdfggff***-001\www\db\GtSEPdb.mdb"

' Create the ADO connection string
conn_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & db_file

' Connect to the database
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open conn_str

' Test the connection
If Err.Number <> 0 Then
  Response.Write "Connection failed: " & Err.Description
Else
  Response.Write "Connected successfully"
End If

' Perform a query
query = "SELECT * FROM your_table"
Set rs = conn.Execute(query)

' Process the results
While Not rs.EOF
  ' Do something with the data
  rs.MoveNext
Wend

' Close the connection
rs.Close
Set rs = Nothing
conn.Close
Set conn = Nothing
%>

<?php
$mdbFilename=$_SERVER["DOCUMENT_ROOT"] . "/housing/admin/123/testy.mdb"; 
echo"data".$mdbFilename;
$user=" ";
$password=" ";
$conn = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);
if($conn)
{
echo "connected";
}
else(!$conn)
  {
    exit("Connection Failed: " . $conn);
}
?>

// Set the database file path and name
$db_file = $_SERVER["DOCUMENT_ROOT"] . "/housing/admin/123/testy.mdb";

// Create the ODBC connection string
$conn_str = "odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=$db_file";

// Connect to the database
$conn = new PDO($conn_str);

// Test the connection
if (!$conn) {
  die("Connection failed: " . print_r(odbc_error(), true));
} else {
  echo "Connected successfully";
}

// Perform a query
$query = "SELECT * FROM your_table";
$result = $conn->query($query);

// Process the results
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
  // Do something with the data
}

// Close the connection
$conn = null;

<connectionStrings>
    <add name="DatabaseGtSEPdb.accdb1" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=h:\root\home\fdfggff***-001\www\db\GtSEPdb.accdb;Jet OLEDB:Database Password=Gt01;Jet OLEDB:Database Locking Mode=1;Mode=16" providerName="System.Data.OleDb" />
  </connectionStrings>

•  You can use the System.Data.OleDb namespace. Connect to an Access database using OleDb in ASP.NET:      

// Set the database file path and name
string dbFile = @"h:\root\home\fdfggff***-001\www\db\GtSEPdb.mdb";

// Create the OleDb connection string
string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbFile;

// Connect to the database
OleDbConnection conn = new OleDbConnection(connStr);
conn.Open();

// Test the connection
if (conn.State == ConnectionState.Open)
{
  Console.WriteLine("Connected successfully");
}
else
{
  Console.WriteLine("Connection failed");
}

// Perform a query
string query = "SELECT * FROM your_table";
OleDbCommand cmd = new OleDbCommand(query, conn);
OleDbDataReader reader = cmd.ExecuteReader();

// Process the results
while (reader.Read())
{
  // Do something with the data
}

// Close the connection
conn.Close();