[AccessD] AXP mde fe / be to fe / MSDE

Martin,

Thanks for the "heads-up."  I know you are under an NDA and cannot
disclose more at this time, but you have said enough to warn us not to
get locked-in to only one approach.

Charles Wortz
Software Development Division
Texas Education Agency
1701 N. Congress Ave
Austin, TX 78701-1494
512-463-9493
CWortz at tea.state.tx.us



-----Original Message-----
From: Mwp.Reid at Queens-Belfast.AC.UK
[mailto:Mwp.Reid at Queens-Belfast.AC.UK] 
Sent: Friday 2003 Mar 07 08:20
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP mde fe / be to fe / MSDE

Arthurs point is a valid one but At some future point in the distant
future 
the ability to work with SQL Server outside the world of ADPs may help
you.

I am sorry thats all I can say. 

Martin



Quoting "John W. Colby" <jcolby at colbyconsulting.com>:

> One of the advantages is that everything you had originally still 
> works.  I am using something similar while I migrate another FE to an 
> ADP.
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-admin at databaseadvisors.com
> [mailto:accessd-admin at databaseadvisors.com]On Behalf Of Arthur Fuller
> Sent: Friday, March 07, 2003 8:21 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] AXP mde fe / be to fe / MSDE
> 
> 
> I don't see the point of this approach. In fact I think it would 
> complicate your problem rather than simplifying it, since you'd get 
> all the problems
> and none of the benefits. Instead I suggest:
> 
> A) make a copy of both the FE and BE.
> B) import the BE into the copied FE.
> C) find all record and row sources that begin with the word SELECT and

> change them to saved queries.
> D) run the upsizing wizard on this new combined FE-BE. You will end up

> with an MSDE database and an ADP FE that directly points to the 
> database rather
> than going through ODBC.
> 
> Now you can enjoy the benefits: speed, direct access to stored 
> procedures, UDFs and views.
> 
> HTH,
> Arthur