Adp to asp web page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DesCF - 21 Oct 2006 18:16 GMT

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 ?

Signature

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

Reply to this Message

Norman Yuan - 22 Oct 2006 16:56 GMT

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.

> 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 ?

Reply to this Message

DesCF - 23 Oct 2006 06:28 GMT

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) ?

> If the Order Form in the adp project is not Data Page (I doubt it is),
> then
[quoted text clipped - 14 lines]
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Signature

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

Reply to this Message

Norman Yuan - 23 Oct 2006 15:18 GMT

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...

>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
[quoted text clipped - 19 lines]
>>> --
>>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply to this Message

DesCF - 23 Oct 2006 18:28 GMT

Thanks for that. Interesting. I went and opened an ADP and everything
seemed to be working just fine including creating a new table. However,
when I went into the connection box, it listed my server but in the drop
down list it was not listed - in fact when I dropped the list it
automatically attached '\SQLEXPRESS' to my server name. My databases were
no longer available and the connection failed. So I removed '\SQLEXPRESS'
and everything worked fine again. As far as I know there is only SQL
Server 8 on my machine now so I went into Program Files\Microsoft SQL
Server to see what is there. There are 2 folders, one called MSSQL and
the other called MSSQL.1. My databases are in the MSSQL\Data folder along
with master and model and so forth. The new stuff (incuding master and
model, etc.) is in the MSSQL.1\MSSQL\Data folder. What would you think be
the conclusion to draw from this ?

> Since you are talking Access ADP and ASP web application:
>
[quoted text clipped - 44 lines]
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Signature

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

Reply to this Message

dbahooker@hotmail.com - 23 Oct 2006 22:00 GMT

you should run out and buy a copy of Dreamweaver; MIcrosoft is a bunch
of drunk retards that dont understand web development

> Thanks for that. Interesting. I went and opened an ADP and everything
> seemed to be working just fine including creating a new table. However,
[quoted text clipped - 61 lines]
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply to this Message

Kevin3NF - 24 Oct 2006 15:43 GMT

You have SQL 2000 and 2005 on your server is my guess...

> Thanks for that. Interesting. I went and opened an ADP and everything
> seemed to be working just fine including creating a new table. However,
[quoted text clipped - 58 lines]
>>> --
>>> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Reply to this Message