I have an access 2003 project connected to an SQL server 2005. The issue that I am having is that I can no longer create or edit tables, stored procedures, queries or anything else as I get a message stating that the version of access that I am using was released prior to the sql server that I am connecting to.

As far as I know there has not been been any new releases of access after 2003. Will I need to wait for a new release of access in order to be fully compatible with SQL 2005?

I have all the office updates, .net 2.0, visual studio 2005 tools for office and service pack 2 for office.

What am I missing?

Thanks,
Jesse

__________________
Thanks,
Jesse

Anything?
Anybody?

Thanks,
Jesse

Hello Jesse,

We have had the same problems after changing
from MSSQL2000 to MSSQL2005.
The complete Development Mode for Queries/Views in our Access2003.adp is locked and must be done with the new
Enterprise-Manager direkt in SQL-Server 2005.

Unfortunately we are missing the sort of all Views
because orderby in a View is not supported in MSSQL2005.

Best regards
Gerhard

I have given up and stopped following Microsoft's distorted view of developers like a lost puppy and jumped ship.

I am now developing my database front ends on Dreamweaver Studio 8. After many years I have come to the point that I can't afford to develop applications based on unstable and unsuported platforms such as MS Access.

Thanks,
Jesse