Post reply

creating forms to enter data

  • June 13, 2009 at 9:41 am

    #201395

    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.

  • June 13, 2009 at 10:53 am

    #1009106

    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

  • June 13, 2009 at 11:00 am

    #1009107

    thank you so much..

  • June 13, 2009 at 11:02 am

    #1009110

    and is there any way to combine access forms with sql?

  • June 13, 2009 at 11:06 am

    #1009113

    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

  • June 13, 2009 at 11:06 am

    #1009114

    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[/url]

    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.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 13, 2009 at 11:12 am

    #1009117

    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

  • June 13, 2009 at 11:12 am

    #1009118

    thank u for ur replies..

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply