Post reply

Wanting to develop quick GUI to access MS SQL database

  • November 28, 2018 at 2:36 am

    #369201

    First post to this site, so hope someone can help me !
    I am an experienced database SQL user having worked with Informix, Sybase, MS-SQL and Oracle for more
    than 20 years.

    I am currently attending an MS Certified course and  joined these forums for hints / guidance

    To test myself I am writing / designing an application which
    will be used to manage resources in my friends music studio.

    I am very happy that I know most of how to design and implement  the database structure in MS-SQL but I also want to write a front end for 
    the users to enter / amend information and view reports.

    I have over 20 years experience in development in C/C++/C#/Java/Perl development but very little GUI  /  Web development experience.
    I'd appreciate very much is someone could point me at a way in which I can develop a quick , dirty application to retrieve / edit / save
    info to/from the database that I can refine later ?

    Many Thanks
    Niall

  • November 28, 2018 at 2:45 am

    #2014760

    You could try PowerApps.
    https://powerapps.microsoft.com/en-us/
    Very quick and easy...

  • November 29, 2018 at 12:07 pm

    #2014992

    Or even just MS Access.

    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura

  • November 29, 2018 at 6:26 pm

    #2015032

    n_macpherson - Wednesday, November 28, 2018 2:36 AM

    First post to this site, so hope someone can help me !
    I am an experienced database SQL user having worked with Informix, Sybase, MS-SQL and Oracle for more
    than 20 years.

    I am currently attending an MS Certified course and  joined these forums for hints / guidance

    To test myself I am writing / designing an application which
    will be used to manage resources in my friends music studio.

    I am very happy that I know most of how to design and implement  the database structure in MS-SQL but I also want to write a front end for 
    the users to enter / amend information and view reports.

    I have over 20 years experience in development in C/C++/C#/Java/Perl development but very little GUI  /  Web development experience.
    I'd appreciate very much is someone could point me at a way in which I can develop a quick , dirty application to retrieve / edit / save
    info to/from the database that I can refine later ?

    Many Thanks
    Niall

    If you link to your SQL Server tables, then you can use Access as a front end. I'd write passthrough queries in Access (so Access will ignore them and just pass them back to SQL Server) to execute your stored procedures/views. Be advised that SQL Server and Access are similar, but not the same when it comes to querying.... get ready for a fun learning curve.

  • November 29, 2018 at 6:37 pm

    #2015033

    autoexcrement - Thursday, November 29, 2018 12:07 PM

    Or even just MS Access.

    I'd go with Access.

  • November 30, 2018 at 1:13 am

    #2015058

    I had the same problem a few time ago...
    and decided that for me it was worthing spending a little time learning ReactJs.
    I did found the framework very easy to learn if you came from c# and desktop components development experience, ad it uses the same paradigm
    I think you may build a dirty web app in a couple of weeks, you can use a lot of good component packages out there such as Material UI, Semantic UI and blueprint

  • December 4, 2018 at 1:25 pm

    #2015501

    pietlinden - Thursday, November 29, 2018 6:26 PM

    n_macpherson - Wednesday, November 28, 2018 2:36 AM

    First post to this site, so hope someone can help me !
    I am an experienced database SQL user having worked with Informix, Sybase, MS-SQL and Oracle for more
    than 20 years.

    I am currently attending an MS Certified course and  joined these forums for hints / guidance

    To test myself I am writing / designing an application which
    will be used to manage resources in my friends music studio.

    I am very happy that I know most of how to design and implement  the database structure in MS-SQL but I also want to write a front end for 
    the users to enter / amend information and view reports.

    I have over 20 years experience in development in C/C++/C#/Java/Perl development but very little GUI  /  Web development experience.
    I'd appreciate very much is someone could point me at a way in which I can develop a quick , dirty application to retrieve / edit / save
    info to/from the database that I can refine later ?

    Many Thanks
    Niall

    If you link to your SQL Server tables, then you can use Access as a front end. I'd write passthrough queries in Access (so Access will ignore them and just pass them back to SQL Server) to execute your stored procedures/views. Be advised that SQL Server and Access are similar, but not the same when it comes to querying.... get ready for a fun learning curve.

    I've never found a way to parameterize pass through queries in Access. Do you know how to do that? I don't mind being misinformed on this one! I think ado or dao would be ok. Just curious!

  • December 10, 2018 at 12:53 pm

    #2015934

    patrickmcginnis59 10839 - Tuesday, December 4, 2018 1:25 PM

    pietlinden - Thursday, November 29, 2018 6:26 PM

    n_macpherson - Wednesday, November 28, 2018 2:36 AM

    First post to this site, so hope someone can help me !
    I am an experienced database SQL user having worked with Informix, Sybase, MS-SQL and Oracle for more
    than 20 years.

    I am currently attending an MS Certified course and  joined these forums for hints / guidance

    To test myself I am writing / designing an application which
    will be used to manage resources in my friends music studio.

    I am very happy that I know most of how to design and implement  the database structure in MS-SQL but I also want to write a front end for 
    the users to enter / amend information and view reports.

    I have over 20 years experience in development in C/C++/C#/Java/Perl development but very little GUI  /  Web development experience.
    I'd appreciate very much is someone could point me at a way in which I can develop a quick , dirty application to retrieve / edit / save
    info to/from the database that I can refine later ?

    Many Thanks
    Niall

    If you link to your SQL Server tables, then you can use Access as a front end. I'd write passthrough queries in Access (so Access will ignore them and just pass them back to SQL Server) to execute your stored procedures/views. Be advised that SQL Server and Access are similar, but not the same when it comes to querying.... get ready for a fun learning curve.

    I've never found a way to parameterize pass through queries in Access. Do you know how to do that? I don't mind being misinformed on this one! I think ado or dao would be ok. Just curious!

    Can;t say I ever bothered trying to create a parameterized version of a pass-through query.   If I needed a stored procedure in SQL Server, I always did the execution using ADO code within VBA.   Much easier to control and provided a LOT more flexibility than any other methodology.   Did it take more time?   Yep.   Worth every additional minute, ten times over.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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