OS: Vista SP1
SQL Server 2008 Express Edition installed locally
Office 2007 installed locally
I'm trying to add a linked server to a named instance of the SQL Server 2008 that links to an Access 2007 database.
I've spent a couple of hours trying this now - many, manyÃÂ different ways.
Always seem to end up back at Error 7303 - http://msdn.microsoft.com/en-us/library/aa226395(SQL.80).aspx
I've tried all versions of Access database file 2000, 2002-2003, 2007
I've tried to use different drivers -
Office 12 for Access driver
I've tried to use the upsizing wizard from Access - no good, cannot get it to connect to the SQL Server 2008 Express Edition instance
Whichever way I try it I end up with this message/error:
the upsizing wizard only works with microsoft sql server versions 6.50 sp5 or higher
I've read: http://support.microsoft.com/default.aspx/kb/838594
ÃÂ and followed it - same error.
I really want this to just work. Like it should already.
Any suggestions appreciated.
View Complete Post