I have to agree nothing is faster than access for basic data entry forms.
Simple front end for sql database.
A database editor suitable as front end for all your relational databases.
Now that we have a front end we re going to create the database.
I am a sql server dba and have a database that i would like to access via a web browser.
But it has to be portable i mean it should be used without additional installation of any program.
For starters it s likely that your client s users will be more familiar with it and it s relatively easy to put.
Developer 2 points 1 year ago.
That front end interface will be used by many users for input data into database.
We could do this through the gui of sequelpro or whatever database manager we re using but i want to show you how to do it with actual sql statements and php in an installer script.
Can you please help and suggest me.
Dnn is a huge investment in time for a simple db front end.
1 point 1 year ago.
Ms access can be used as the front end for an sql server database though it s usually a better idea to create a web app.
I am not a developer although i m pretty good at sql and scripting with powershell.
Sql structured query language is a language used to communicate with a database.
It will be used internally on the intranet and will simply be calling stored procedures in sql server to enter data into the database and return data into a simple web page.
What are the advantages of using access as the front end to a sql server database.
Connects to oracle db2 mysql and many other databases.