Developer 2 points 1 year ago.
Simple front end for sql database.
Dnn is a huge investment in time for a simple db front end.
Now that we have a front end we re going to create the database.
Can you please help and suggest me.
Connects to oracle db2 mysql and many other databases.
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.
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.
I am not a developer although i m pretty good at sql and scripting with powershell.
What are the advantages of using access as the front end to a sql server database.
1 point 1 year ago.
I have a sql server database i want a front end graphical user interface for data input which can be either web or desktop.
A database editor suitable as front end for all your relational databases.
Used to easily query update and administer your database create reports and synchronize data.
That front end interface will be used by many users for input data into database.
But it has to be portable i mean it should be used without additional installation of any program.
Using access as a front end to sql backend need tutorials hi everyone with some extra time available compliments of covid lock down i have decided to try converting our main access system to use sql server as the back end db and learn how to drive sql.
I have to agree nothing is faster than access for basic data entry forms.
I am a sql server dba and have a database that i would like to access via a web browser.