SQL Server database Software Viewer/editor
Hi all,
Does anyone know of a bit of software that will enable me to connect to a setup SQL server, view the tables in a database, an allow values to be edited.
Basicly what I would like, is very much like a form in MS Access, but only this, as a sperate client bit of software.
I would like to be able to design this form, what it looks like, layout, and link tables together, so showing a record at the time. Effectivly the user, can then login with this, and access data, and amend, add etc directly to a SQL server. Validation would also be great?
MS Excel effectivly does this, but is only read only, and I need to edit and posibly validate.
If there is not software, does anyone know how to create this with VB objects, plugins, etc?