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