issues using MS Access with SQL Server 2005

I'm trying to help my clients configure MS Access to run queries against a
SQL Server 2005 on a hoste providers server.
I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
the following error:
"This version of Microsoft Access deosn't support design changes with the
version of MS SQL Server your Access project is connected to. Your design
changes will not be saved."
My client, using Access 2003 gets a similar message and cannot save the view
she designed.
Is there something we have to configure on the hosted server to allow use of
Access?
Thanks for any assistance with this.Dabbler wrote:
> I'm trying to help my clients configure MS Access to run queries against a
> SQL Server 2005 on a hoste providers server.
> I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> the following error:
> "This version of Microsoft Access deosn't support design changes with the
> version of MS SQL Server your Access project is connected to. Your design
> changes will not be saved."
> My client, using Access 2003 gets a similar message and cannot save the view
> she designed.
> Is there something we have to configure on the hosted server to allow use of
> Access?
> Thanks for any assistance with this.
Access ADP doesn't support modifications to SQL Server 2005 objects.
The easiest way to modify views is to use SQL Server Management Studio.
It seems to be unclear at the moment what the future of ADP is:
http://www.databaseadvisors.com/gazette/sqlexpress.htm
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks for the lowdown on this. Not sure what MS is thinking with regard to
the primary market for Access end users, I don't think SQL Server Management
Studio is appropriate for end users.
"David Portas" wrote:
> Dabbler wrote:
> > I'm trying to help my clients configure MS Access to run queries against a
> > SQL Server 2005 on a hoste providers server.
> >
> > I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> > the following error:
> > "This version of Microsoft Access deosn't support design changes with the
> > version of MS SQL Server your Access project is connected to. Your design
> > changes will not be saved."
> >
> > My client, using Access 2003 gets a similar message and cannot save the view
> > she designed.
> >
> > Is there something we have to configure on the hosted server to allow use of
> > Access?
> >
> > Thanks for any assistance with this.
> Access ADP doesn't support modifications to SQL Server 2005 objects.
> The easiest way to modify views is to use SQL Server Management Studio.
> It seems to be unclear at the moment what the future of ADP is:
> http://www.databaseadvisors.com/gazette/sqlexpress.htm
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>|||Microsoft is really screwing up by not supporting SQLS2005 design work within
ADPs. So now I'm going to purchase the older SQLS2000 instead of 2005 to
accomplish what my users require? Seems counter-advancement. At least this
will save about $4000 with std. edition. As Dabbler says, SQLS Management
Studio is not appropriate for end users.
"Dabbler" wrote:
> Thanks for the lowdown on this. Not sure what MS is thinking with regard to
> the primary market for Access end users, I don't think SQL Server Management
> Studio is appropriate for end users.
> "David Portas" wrote:
> > Dabbler wrote:
> > > I'm trying to help my clients configure MS Access to run queries against a
> > > SQL Server 2005 on a hoste providers server.
> > >
> > > I'm using Access 2002 (10.6771.6735) SP3. When I try and design a view I get
> > > the following error:
> > > "This version of Microsoft Access deosn't support design changes with the
> > > version of MS SQL Server your Access project is connected to. Your design
> > > changes will not be saved."
> > >
> > > My client, using Access 2003 gets a similar message and cannot save the view
> > > she designed.
> > >
> > > Is there something we have to configure on the hosted server to allow use of
> > > Access?
> > >
> > > Thanks for any assistance with this.
> >
> > Access ADP doesn't support modifications to SQL Server 2005 objects.
> > The easiest way to modify views is to use SQL Server Management Studio.
> >
> > It seems to be unclear at the moment what the future of ADP is:
> > http://www.databaseadvisors.com/gazette/sqlexpress.htm
> >
> > --
> > David Portas, SQL Server MVP
> >
> > Whenever possible please post enough code to reproduce your problem.
> > Including CREATE TABLE and INSERT statements usually helps.
> > State what version of SQL Server you are using and specify the content
> > of any error messages.
> >
> > SQL Server Books Online:
> > http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> > --
> >
> >