Share via

Microsoft SQL Server Express

Anonymous
2015-10-19T22:38:02+00:00

I have downloaded MS SQL SERVER express with the advanced option.

I would like some advice on a few things i am new to this:

  1. Can you connect to a front end like MS Access to display the data in a more user friendly way?
  2. If im running a HTML form on a network server that outputs the details to the SQL express DB and email where can i run SQL express?
Microsoft 365 and Office | Install, redeem, activate | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-10-20T13:35:14+00:00

    Hello,

    You can create an Access project or use linked tables in Access to use Access as front-end and SQL Server as back-end. This way you can take advantage to all Microsoft Access wizards for Forms  and Reports.

    https://support.office.com/en-us/article/Link-to-SQL-Server-data-0474C16D-A473-4458-9CF7-F369B78D3DB8

    http://www.databasedev.co.uk/access2007adp.html

    You can place the SQL Server instance on the same server as the Web server or on another computer on the organization network. SQL Server Express only uses 1 GB of RAM and 1 physical CPU.

    Hope this helps.

    Regards,

    Alberto Morillo

    SQLCoffee.com

    Was this answer helpful?

    0 comments