Question about forms in SQL

At first this seemed like a ridiculous question...but I thought I would go
ahead and ask it as I am new to SQL and experienced in MS Access.
Is there a way to have "forms" in SQL similar to the forms in MS Access? I
realize that I could just write code, i.e. ASP, and create forms, but is
there a way to have forms within SQL? How about in the newer versions?
Thanks!!Hi,
No, SQL Server do not have any forms. But you can use the forms available in
Access / VB and other development tools to
structure the front end.
Thanks
Hari
MCDBA
"michaaal" <res0gyio@.verizon.net> wrote in message
news:ebj0ye8EEHA.3336@.TK2MSFTNGP12.phx.gbl...
> At first this seemed like a ridiculous question...but I thought I would
go
> ahead and ask it as I am new to SQL and experienced in MS Access.
> Is there a way to have "forms" in SQL similar to the forms in MS Access?
I
> realize that I could just write code, i.e. ASP, and create forms, but is
> there a way to have forms within SQL? How about in the newer versions?
> Thanks!!
>|||How do you connect Access to SQL? Is it easy or do I need to do a bunch of
coding?|||Hi,
It's not that difficult but, yes, you have to code it in vb or vb .net or
any other high level language.
HTH,
Bernie Yaeger
"michaaal" <res0gyio@.verizon.net> wrote in message
news:%23zlhu7AFEHA.2628@.TK2MSFTNGP11.phx.gbl...
> How do you connect Access to SQL? Is it easy or do I need to do a bunch
of
> coding?
>|||"michaaal" <res0gyio@.verizon.net> wrote in message
news:%23zlhu7AFEHA.2628@.TK2MSFTNGP11.phx.gbl...
> How do you connect Access to SQL? Is it easy or do I need to do a bunch
of
> coding?
First create a DSN for your SQL server in Data Sources (ODBC) in Windows
File > Get External Data > Link Tables...
In the dialog box go to Files of type: and choose ODBC. Select the DSN you
have created. And Bob's your uncle
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.644 / Virus Database: 412 - Release Date: 26/03/2004|||It depends on the version of Access. From Access 2000 on it is pretty easy,
situation was further improved with Access 2002. Usage of SQL Server
doesn't usually require any more coding than is required for the use of
Access' default JET database.
For example (using Access 2003, but I think 2002 is the same) you just say
File->New and then select "Project using existing data...". Specify the
project name, select create, and it leaves you in the Data Link properties
page. Set up the properties to allow connection to your existing SQL Server
database and you are ready to go with normal Access form/report development!
Hal Berenson, SQL Server MVP
VP, Yukon Readiness
Scalability Experts, Inc.
"michaaal" <res0gyio@.verizon.net> wrote in message
news:%23zlhu7AFEHA.2628@.TK2MSFTNGP11.phx.gbl...
> How do you connect Access to SQL? Is it easy or do I need to do a bunch
of
> coding?
>