Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

creating forms to enter data Expand / Collapse
Author
Message
Posted Saturday, June 13, 2009 9:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 10, 2009 10:02 PM
Points: 21, Visits: 21
i jst want to know whether there is any way that i can create forms in sql server like we do in Ms Access.
any help would be appreciated.
Post #734351
Posted Saturday, June 13, 2009 10:53 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 2,087, Visits: 3,932
Welcome on SSC

No, it's not possible to create Forms like in Access with SQL Server. You can create reports with Reporting Services.

To create forms use a client-side technology like .Net (C#/VB.Net/...) or MS-Access.

Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #734372
Posted Saturday, June 13, 2009 11:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 10, 2009 10:02 PM
Points: 21, Visits: 21
thank you so much..
Post #734373
Posted Saturday, June 13, 2009 11:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 10, 2009 10:02 PM
Points: 21, Visits: 21
and is there any way to combine access forms with sql?
Post #734376
Posted Saturday, June 13, 2009 11:06 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 2,087, Visits: 3,932
For sure !

I'm not up-to-date with Access (long time ago) but you can use ADODB or maybe today ADO.NET to connect to almost any kind of database server.

Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #734379
Posted Saturday, June 13, 2009 11:06 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 3,112, Visits: 7,856
smsam1 (6/13/2009)
and is there any way to combine access forms with sql?


I believe you can do that by linking Access to SQL. I haven't done it so I cannot tell you how.





Alvin Ramard
Memphis PASS Chapter

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.
Post #734380
Posted Saturday, June 13, 2009 11:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Sunday, November 4, 2012 12:23 PM
Points: 2,087, Visits: 3,932
Alvin Ramard (6/13/2009)
smsam1 (6/13/2009)
and is there any way to combine access forms with sql?


I believe you can do that by linking Access to SQL. I haven't done it so I cannot tell you how.

Hi Alvin

Usually it is possible to link SQL Server to Access via "adp" Files. But there seems to be a problem with using this feature for SQL Server 2008 (just googled)
http://blogs.msdn.com/access/archive/2009/01/21/adp-s-and-sql-server-2008.aspx

Anyway, connecting via ADODB/ADO.NET is possible and Access can be used a client application.

Flo



The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems
Post #734383
Posted Saturday, June 13, 2009 11:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, December 10, 2009 10:02 PM
Points: 21, Visits: 21
thank u for ur replies..
Post #734384
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse