I am currently using Access 2003 ADP and SQL server 2005 Express. In this conbination, I can not make changes to SQL Server 2005 objects such tables, views, procedures etc from within Access 2003 ADP. I am forced to used SQL Server 2005 Express Management Studio. However, I can not set Access's extended properties through it.
I understand that ADP under Access 2007 supports changing SQL Server 2005 objects. Also under 2007, I can open ADP version 2003 project, modify it and save as version ADP 2003.
Will the 2003 ADP project modified in such a way run on client computers having Access 2003 without problems?
What I am exploring here is using Access 2007 for maintaining Access 2003 ADP projects.
Ashok
I understand that ADP under Access 2007 supports changing SQL Server 2005 objects. Also under 2007, I can open ADP version 2003 project, modify it and save as version ADP 2003.
Will the 2003 ADP project modified in such a way run on client computers having Access 2003 without problems?
What I am exploring here is using Access 2007 for maintaining Access 2003 ADP projects.
Ashok