请问如何连接access 2007和sql server 2005数据库???

access不熟,给你写个sqlserver吧
public class Class1
{
private const string connString = "Data Source=localhost;Initial Catalog=DataBaseName;Integrated Security=True";

public int ExecuteNonQuery(string sql, SqlParameter[] para)
{
using (SqlConnection conn=new SqlConnection (connectionString))
{
int count=0;
try
{
count = BuildCommand(sql, conn, para).ExecuteNonQuery();
}
catch (Exception)
{

throw;
}
finally
{
conn.Close();
conn.Dispose();
}
return count;
}
}
public SqlDataReader ExecuteReader(string sql, SqlParameter[] para)
{
using (SqlConnection conn=new SqlConnection (connString))