[3.0/LINQ] access DB questions

Hi all

I have two questions

1) when i try to connect to a database using
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;"

as my access string i keep getting the error

The 'Microsoft.ace.oledb.12.0' provider is not registered on the local machine.

I have been googleing but havent found an answer yet does anyone know what this means.



2) have the sql query that i developed in excel

"SELECT Games.Pubdate, Games.LeagueID, Leagues.League, Games.Home, Games.Visitor, Games.Start, Games.End
FROM `C:\Documents and Settings\rbarbrow\Desktop\edops db\EdOps_be`.Games Games, `C:\Documents and Settings\rbarbrow\Desktop\edops db\EdOps_be`.Leagues Leagues
WHERE Games.LeagueID = Leagues.LeagueID AND ((Games.Pubdate Is Not Null) AND (Games.End Is Not Null))"


but im not sure how to develop it that the paths are no there . would it just be from Games , Leagues?

thanks

DOh

I got number 1)

I mistakenly was useing the 2007 connection string
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; is the correct string

The FROM clause simply contains the tables you want to get the data from. Excel requires a modified syntax because it's not a real database. Access is and therefore just requires regular SQL syntax. Access also has a Jet SQL reference, so you should have consulted that first.

Also, that is old join syntax. You should perform a join explicitly:

SQL Code:

SELECT ChildTable.ChildColumn, ParentTable.ParentColumn
FROM ChildTable
    INNER JOIN ParentTable
        ON ChildTable.ParentID = ParentTable.ParentID