Re: SQL express 2005 support

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "Mary Chipman [MSFT]" <mchip@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 13 Jan 2006 18:03:09 -0500

You can't use an ADP to create SQL Server 2005 objects. The best way
to go about that is to get the Developer edition of SQLS ($49). It has
all of the tools you need to develop and secure your app. The license
agreement prohibits its use in production.

--Mary

On Wed, 11 Jan 2006 20:32:02 -0800, "ecyyn"
<ecyyn@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>What can I do to make the 2003 Access ADP work with the new SQL Express 2005?
>I know they can connect and retrieve and store, but I mean develop thru ADP
>and make table etc..
>
>Many thanks.
.

Prev by Date: Re: Import data - error message about disk space?
Next by Date: Re: Import to Excel resulting in hash marks and chinese looking ch
Previous by thread: Re: Import data - error message about disk space?
Next by thread: effect of trigger in Access?
Index(es):
- Date
- Thread

Relevant Pages

Re: ADP Vs. ODBC
... that Access connects to SQL Server and consumes server and network ... Actually, an ADP will often hang on to more than one connection, so there's certainly a point there, and I can understand that ODBC gives you greater flexibility, but am I wrong in thinking that it usually requires a significantly increased amount of maintenance and tuning compared to an ADP? ... you can't do back-end design work from an ODBC front-end either. ...
(microsoft.public.access.adp.sqlserver)
A little OT - Quite a rant on microsoft.public.sqlserver.olap
... SQL authentication doesn't work for SQL Server to anywhere. ... reports in ADP; but somehow it's not getting traction. ... thru in order to create forms and reports against a database. ...
(microsoft.public.access.modulesdaovba)
Re: crash on virtual dimensions
... the most important part about ADP is that the tools in an Access Data ... Proejct are better for writing stored procedures and SQL udfs. ... I wrote MDB with forms and reports for 2 years before getting into ... I was able to get into SQL Server, ...
(microsoft.public.sqlserver.olap)
Re: Crosstab REPORT, not query
... you can use the 'Database Tuning Advisor' against the SQL ... other books on ADP? ...
(microsoft.public.access.adp.sqlserver)
Re: Why does SQL server 2005 not work with Access 2003 Projects (adps)?
... it's a total load of crap that ADP 2003 won't update SQL 2005. ... database but I can hardly do anything with it. ... Why can't such an interface be a selectable option in SQL server ...
(microsoft.public.access.adp.sqlserver)