Home Forums SQL Server 2008 SQL Server 2008 - General Is there a better way to insert data than Access? RE: Is there a better way to insert data than Access?

  • April 16, 2013 at 2:44 am

    #1606736

    foxxo (4/16/2013)

    If the problem is that managers need access to a single point of truth for data, then you need a database, or a data mart.

    Is it structured or unstructured data that you want to store?

    The data is structured.

    The technical staf uses SSMS for inserts and mutations. SSMS is general and uses info from SQL-server to insert and mutate, for example using the "Edit Top 200 Rows". We do not want to provide database access by SSMS for the managers. Also we want that the user gets some help when there are relational constraints, for example with a pick list for smal related tables or with a 'browsing' mode for the larger tables.

    Ben