Access 2002/XP Access Project (ADP) and SQL Server 2005

[Greg]

Access 2002/XP will not allow me to design any SQL Server 2005 objects. An
error appears saying my version of Access is older than the version of SQL
Server I am running. I'm instructed to go to Microsoft Downloads for a
solution, but cannot find any solutions on what to do.

Is it possible to modify SQL Server 2005 Tables, Stored Procedures, etc.
from and Access 2002/XP Project? You can edit the SQL Server Objects if it's
SQL Server 2000.

Thanks in advance for any insight on this issue.

Greg

 

[Robert Morley]

This has been discussed to no end on this and other lists, but no, there's
nothing simple that you can do to make ADP's able to edit SQL Server 2005
objects. The best you can do is put SQL Server 2005 into SQL Server 2000
compatibility mode, which means--of course--that you can't take advantage of
the new functionality of SQL Server 2005.


Rob

 

[PBsoft]

Is it possible to modify SQL Server 2005 Tables, Stored Procedures,

etc. from and Access 2002/XP Project?

It isn't possible.

Anyway, you can youse SQL Server Management Studio to create views, stored
procedure, functions, user data type, or to manipulate tables, relations,
indexes, etc....

 

[aaron.kempf]

SSMS express is a free download; of course you should be using it

microsoft.com/sql download sql 2005 express with advanced tools