How and what option do you choose to design Forms in SQL
like the ones in Access 2000-2002?

Re: Form Desig for SQL Server 2000 by Henry

Henry
Fri Sep 19 13:09:52 CDT 2003

None !
You don't design Forms in SQL Server

SQL Server is an Database Engine while Jet is the default Database for MS
Access.

MS Access is an Application that acts as a programmable Front-End for Jet,
MSDE, SQL Server and other Databases ( be they relational or flat file, via
ODBC )

You can create Forms Interfaces for SQL Server in MS Access, Visual Basic,
ASP, .Net, C#, Delphi, Cold Fusion or any number of other "Languages' that
allow you to create Applications or Programmable Interfaces.

What you see in SQL Server is a Management console ( Which in SQL Server
2000, borrows many of the UI Features developed for MS Access.) - This does
not mean however that the Management Console is an Application
Development Tool like MS Access and shouldn't be mistaken for one.

If you need help interfacing between MS Access and SQL Server I'd suggest
you post to comp.databases.ms-access where there is a wealth of resources
and talent to help you.

Hope this helps.

Henry Craven
------------------
31 Oct = 25 Dec

"DC" <d2674@cfl.rr.com> wrote in message
news:0e6801c37ed4$a8fc4f20$a001280a@phx.gbl...
> How and what option do you choose to design Forms in SQL
> like the ones in Access 2000-2002?



Re: Form Desig for SQL Server 2000 by DC

DC
Fri Sep 19 13:56:43 CDT 2003

Henry-
Thanks for clearing that up for me as I'm pretty strong
with Access and most of the Front-End apps, I'm just being
forced into the convergance between the two being specific
to designing Front-End web type of interfaces that connect
to an SQL server-thanks again
>-----Original Message-----
>None !
>You don't design Forms in SQL Server
>
>SQL Server is an Database Engine while Jet is the default
Database for MS
>Access.
>
>MS Access is an Application that acts as a programmable
Front-End for Jet,
>MSDE, SQL Server and other Databases ( be they relational
or flat file, via
>ODBC )
>
>You can create Forms Interfaces for SQL Server in MS
Access, Visual Basic,
>ASP, .Net, C#, Delphi, Cold Fusion or any number of
other "Languages' that
>allow you to create Applications or Programmable
Interfaces.
>
>What you see in SQL Server is a Management console (
Which in SQL Server
>2000, borrows many of the UI Features developed for MS
Access.) - This does
>not mean however that the Management Console is an
Application
>Development Tool like MS Access and shouldn't be mistaken
for one.
>
>If you need help interfacing between MS Access and SQL
Server I'd suggest
>you post to comp.databases.ms-access where there is a
wealth of resources
>and talent to help you.
>
>Hope this helps.
>
>Henry Craven
>------------------
>31 Oct = 25 Dec
>
>"DC" <d2674@cfl.rr.com> wrote in message
>news:0e6801c37ed4$a8fc4f20$a001280a@phx.gbl...
>> How and what option do you choose to design Forms in SQL
>> like the ones in Access 2000-2002?
>
>
>.
>

Re: Form Desig for SQL Server 2000 by Henry

Henry
Fri Sep 19 20:39:27 CDT 2003

If you're creating a Web Interface to a database on the SQL Server that
comes as part of MS Small Business Server, be advised that you are only
licensed for clients in the SBS Domain/Intranet to access the SQL Server.

If you want to access the data from the Internet, you will have to purchase
a Full Package Product SQL Server with the appropriate license(s) ( most
likely Per-Processor ).

It is also advisable to host this SQL Server on a separate Box from the Web
Server for security reasons ( in addition to performance considerations )

Henry Craven
----------------
2b XOR 2b

"DC" <d2674@cfl.rr.com> wrote in message
news:0fdb01c37edf$c46c6230$a001280a@phx.gbl...
> Henry-
> Thanks for clearing that up for me as I'm pretty strong
> with Access and most of the Front-End apps, I'm just being
> forced into the convergance between the two being specific
> to designing Front-End web type of interfaces that connect
> to an SQL server-thanks again