Easy database userface

Question

I have a simple SQL Server database that we use for conversions. Basically a table with two mor more columns where one value maps to another. We then have processes that use these tables to find matching values and select other values on that row.

These values change a lot and we now need a interface for the business users to update the values themselves. I don't want to spend time building something new, I rather use and interface that the uses are used to - for example Excel or something in SharePoint.

Have you solved something similar and what your idea for a easy win in the scenario?

Answer 1

You can map the SQL Server table into an Access "table" (I forget the exact Access term for this "table" type.)

Result will be that your users can use the Access tools, including the grid, to change the data on the actual server.

Remember to create user names on the SQL Server that only have the minimum permissions needed to do the valid tasks. Eg do the users need insert or delete ability on the rows? Or just update ability?

Larry

Answer 2

You could either use ASP.Net Dynamic Data scaffolding or use the Business Data Catalog if you have MOSS 2007 Enterprise with some off-the-shelf web parts which enable write-back capability.

Answer 3

I think Acces is better than Excel for this purpose as you can create the code to really limit what they can use as acceptable values much more easily.

Another possiblility is a web-based form (or application depending on how complex this is) that you create in .net or some other language depending on what you know. As long as they have the web address and the form is fairly straightforward, your users will have no trouble with this. Make it available only on the intranet and not to the outside world and require usernames and passwords and it is as secure as the other possibilites being floated around. One real advantage of this is that when change time comes around you can easliy deply changes. One disadvantage is it is more complex to originally set up than an Access form.

Answer 4

Riri, Check this Database Query tool features, you'll find it helpful. (its still a beta so its free, for now)