Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Express

MS Access adp queries and SQL Serv 2005 express

I have upsized some Access 2002 tables to Sql Server 2005 express. I put together a query and when I try to execute it, it tells me the MS Access is an earlier version prior to SQL server 2005 and it will not save the queries. When I try to run them anyway, I get the repeated message and the query never executes. I'm taking a T-SQL class and this is how the instructor. Is they a fix for SQL Server or Access to get around this or do I have to revert back to MDSE 2000? Can MDSE 2000 and SQL Server be loaded onto the same machine (laptop)? Help!!!!! I am very new at this...
[586 byte] By [Tom414] at [2007-12-25]
«« How to use btn.RaiseEvent to fire button click event?
»» Will there be a Beta 2 of framework?
# 1

Hi Tom,

You get this message because the SQL designers in Access 2002 do not work against SQL Server 2005. This is unfortunatly the expected behavior and won't be corrected until Access 2007 is released. This problem is not unique to Access 2002, it also happens in Access 2003 and Visual Studio 2002/2003, it is caused by the fact that these products all use a version of the designers that were created prior to SQL 2005 and they don't understand some of the structures in SQL 2005.

Designers that do work against SQL Server 2005 (including Express) are available in Management Studio Express, which you can download from http://msdn.microsoft.com/vstudio/express/sql/download.

Mike

MikeWachal-MSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Express...
# 2

Mike,

Your answer indiacates that we can not use Access XP (Project) as front end to SQL server 2005. Somehow Microsoft does not utter a word about this. I have also tried many solutions for this but none of them is found useful. Can any won suggest (me / ) access developer comunity as such the solution to use Access XP /2003 as front end with SQL Server 2005 at the backend?

DeepakDiwan at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Express...
SQL Server
SQL Server Express

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified