is there a simple front for sql server?

Question

i am in a multi-user environment

i am using access as a front end connecting to sql server database. i am allowing users to edit only one table in sql server.

i dont want to continue using access to edit a sql-server table.

can someone recommend another tool to do this?

Answer 1

The Access 2007 runtime and the Access 2010 runtime is free for the download from Microsofts website. Of course you'd want to purchase Access licenses for power users who want to create their own queries usually for export to Excel.

Answer 2

Either Access or Excel are almost certainly the simplest solutions available that meet your requirements, when you consider both the simplicity of the user interface itself and the simplicity of implementing, deploying, and maintaining the solution for the users. Creating even a simple web page isn't nearly so simple – you'll need to setup a web server, configure user security, develop the web page, etc.