Re: Adp to asp web page

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

Since you are talking Access ADP and ASP web application:

1. Access ADP is merely front end app and IDE for SQL Server, and it is
desktop technology (forget data page, it is gone in Access2007 anyway), so
different from web app (ASP or ASP.NET), you cannot "convert" onw to the
other, unless "converting" means complete re-write.

2. ASP is old technology and different from ASP.NET. With Visual Studio Web
Express2005, you can only develop ASP.NET, not ASP.

3. Sql Server Express is a database server, ( SQL Server 2005), and can be
used with ASP, ASP.NET, Access APD (though, you cannot design table, view,
SP and UDF with Access2003 and older on SQL Server2005/Express, you need
upcomming Access2007 for that) and other apps...

"DesCF" <descf@xxxxxxx> wrote in message news:op.thuz5l1oupgxg0@xxxxxxxxxxx
I caught on to this after I posted and downloaded Express 2005 Visula Web
Developer and Express 2005 SQL Server. Is this the latest software and
the accepted way of doing this now ? Also while on the subject what are
the substantive changes between Access 2002 XP and 2007 (if any) ?

On Sun, 22 Oct 2006 16:56:08 +0100, Norman Yuan <NotReal@xxxxxxxxxxx>
wrote:

If the Order Form in the adp project is not Data Page (I doubt it is),
then
the simplest way is, well, forget the adp at all and do it ASP way. Oh,
you
may re-use or copy the query the form is based on in your ASP project
(view,
SP, or dynamic SQL). Even it is data page, it may still better to do the
ASP
page without bothering to convert it, and data page has been dropped from
Access2007's ADP support.

"DesCF" <descf@xxxxxxx> wrote in message
news:op.thr7l41bupgxg0@xxxxxxxxxxx
What is the simplest and most efficient way to recreate the
NorthwindCS.adp Orders form (with the detail subform) as a .asp (I
assume)
web page ?



--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/





--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/


.

Relevant Pages

  • Re: Browser as Front-End
    ... > I'm trying to build an app. ... That's a question that does not have much to do with SQL Server. ... people seem to use ASP or ASP .Net. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Connection.Execute and SQL stored procedures
    ... ..asp, the connection object and MS SQL Server as the DB can help me out. ... Five of the six calls execute as expected. ... This particular stored procedure does quite a bit of work within the DB, ...
    (microsoft.public.sqlserver.odbc)
  • Re: Heres a rather broad question...
    ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ... IIS user doesn't have the proper permissions to access the database, ...
    (microsoft.public.data.ado)
  • Re: WAP, ASP engineer required - London
    ... > at the company I work for we need to hire in London a WAP ASP engineer ... > You should have experience of SQL Server database design and as ... online service development the ideal ... > candidate will be technically minded and have experience in SQL Server ...
    (microsoft.public.inetserver.asp.general)
  • Re: Need some fresh ideas
    ... I have an upload form that allows a user to browse and select ... asp server script validates the input ... SQL Server to it ... * editFile updates the form data. ...
    (comp.lang.javascript)