Solutions to edit SQL DB for users that do not know SQL
Hi! Recently we have been asked to do a interface to edit some database info for users that do not know anything about SQL. The default answer will be doing an ASP.Net webpart and have it connected to SQL, but I will like to know alternate solutions Sharepoint could provide with any Microsoft Technology, ANY. The problem is this: We have a set of data from a database X from which we make a monthly report We made another new database Y to add some data to the report from X, so the report makes a JOIN between tables from the two DBs We want to make this database Y accessible to people that have no SQL knowledge so that they can edit the tables to add data to the report. I am posting this in Sharepoint since I would like to be accessible to everyone and you don't have to start delivering the application to all the persons that need to use it. But if there is an alternate solution without sharepoint it doesn't matter. Thanks!Carlos Vargas-Montero
December 20th, 2010 11:51am

In SharePoint, you can use BDC to interact with the data. (Max pain and suffering.) If you have Access (Access 2007 preferably), you can use it for data interaction. (Simple, painless, smarter.) Steve Clark, MCTS | Twin-Soft.com
Free Windows Admin Tool Kit Click here and download it now
December 20th, 2010 1:07pm

You could write a custom ASP.NET app and use LINQ to SQL which is pretty easy.http://lbellows.blogspot.com http://www.ptreviews.net
December 20th, 2010 5:23pm

Thank you! I will try with AccessCarlos Vargas-Montero
Free Windows Admin Tool Kit Click here and download it now
January 4th, 2011 12:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics