Link to home
Start Free TrialLog in
Avatar of Aaron Greene
Aaron GreeneFlag for United States of America

asked on

Creating a front end for SQL Server database

I need to create a user form for a SQL Server database.  I have experience using MS-Access as a front end, but the environment that I am currently working with does not have Access.  I am looking for a tool that will let me create a couple data entry forms, without a steep learning curve.
ASKER CERTIFIED SOLUTION
Avatar of Daniel Pineault
Daniel Pineault

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Aaron Greene

ASKER

I was not aware that there was a free ms-access runtime option.  I could possibly set up a web server, but I'd have to get more people involved.
You have to "list" your options..
Access should give you the fastest option to develop a FE...then it's .Net Winforms
An option involving MS-Access would be the best option.  I have experience developing in Access, but the client PC does not have MS-Access installed.
LAMP - Linux + Apache + MariaDB + PHP.

More flexible, install WordPress on LAMP.
Hi,

as Daniel said above, the client can install the free Access runtime version which has no licence fee, no Office needs to be installed.

Cheers,

Christian
In this case, the runtime license is the best option. I have years of experience in developing .mdb solutions, but overall, that seems to be a limited solution. I would like to be able to create a browser based gui for a local SQL database.
If its browser based then its PHP for quick development.
Thank you all for your help.
Hi,

you could also try ASP.NET which is more easy to learn if you come from VBA.
PHP is only a server-side language, you would also need JavaScript on the browser side, so at least two new languages to learn (beside HTML and CSS for design..but that's the same with ASP.NET).

Cheers,

Christian
PHP can handle just fine front end...it just lacks some fancy handling...PHPAdmin the defacto tool for handling MySQL instance is coded in PHP...and personally i have implemented in some extend FE for database applications in PHP...whenver you need the newest tricks you just include them.