Wanting to develop quick GUI to access MS SQL database

Question

Post reply

Wanting to develop quick GUI to access MS SQL database

n_macpherson

SSC Enthusiast

Points: 174
More actions
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

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

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

mark.humphreys SSC Eights! Points: 867 More actions · Answer 1

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

autoexcrement SSCertifiable Points: 5956 More actions · Answer 2

Or even just MS Access.

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

pietlinden SSC Guru Points: 63578 More actions · Answer 3

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.

Steve Jones - SSC Editor SSC Guru Points: 738127 More actions · Answer 4

autoexcrement - Thursday, November 29, 2018 12:07 PM
Or even just MS Access.

I'd go with Access.

carlo.pagliei 63874 Old Hand Points: 327 More actions · Answer 5

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

x SSC-Insane Points: 23660 More actions · Answer 6

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!

sgmunson SSC Guru Points: 110644 More actions · Answer 7

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)

Wanting to develop quick GUI to access MS SQL database

Cookies on SQLServerCentral