-
I need to create a web page that will give managers access to a SQL database. Will these managers be able to update and make changes to the tables from the internet? If so, will you point me in the right direction? I know that I will be using ASP and SQL statements. I am a newbie so go easy on me.
Thanks in advance
-
I dont know very much about SQL server so I may be wrong. Howver I think SQL has something to allow remote administration.
However from a webpage only then you could use SQL statements to manipulate the table structure e.g Create Table, AlterTable etc. I think this works in ASP but am not sure what would happen if the changes would result in loss of data.
Hope this helps,
Alex
-
It is less likely that you would write an App that allows direct manipulation of the database's data and more likely you would write an App that provides an interface to allow the modification of records which can then be updated to the database (quite easliy in fact) using either update statements or (better yet) stored procedures. You will need to decide on an interface and when the data gets updated.