• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 507
  • Last Modified:

User Interface for SQL Server?

Migrating from Access to SQL Server you realise, that you suddenly do not have any user interface....
I have created an Access front end with an ODBC connection to the SQL Server, but surely there must be alternatives?
0
IbDyhr
Asked:
IbDyhr
  • 2
  • 2
2 Solutions
 
Aneesh RetnakaranDatabase AdministratorCommented:
Check for "Sql server manage ment studio "  under start-> programs -> sql server 2005

Or else type "sqlwb.exe" at the start->run  prompt
0
 
jamcosCommented:
The UI for SQL Server is SQL Server Management Studio. The part that is a pain is that it's not installed by default. Managerment Studio is part of the "Workstation components, Book online, and development tools" item in the components to install screen of the setup.  Or, if you pick advanced on the components screen, it's in Client Components / Management Tools.
0
 
IbDyhrAuthor Commented:
Thanks - I already have the Server Management Studio (Express) up and running, but I was thinking along the lines of creating forms and reports - a real application so to speak, and not just table data and query-results.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
there is no other client tools associated with SQL server, if you need to create forms and other stuffs you need to make use of either access forms or some other programmin languages.
0
 
jamcosCommented:
There is SQL Reporting Services...probably way overkill for what you want. http://www.microsoft.com/sql/technologies/reporting/default.mspx
For forms, we write our own ASP.Net applications. It's definitely crossing into a different world than basic Access forms and reports. Using Access as a front end isn't a bad way to go if you are comfortable with it and it does what you need.
0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now