How to deploy an SQL server data base onto a website

[masiwan]

I'm looking for reference material from any website that can quickly take me through how to deploy an SQL Server database onto a website. So that data entry and reporting is done from that website.

Already there is an SQL server data base and an access project connecting to it. Every thing runs fine from the office SQL sever computer. I believe it is still possible to use the Access forms and reports for data capture and display.

 

[adamroof]

You will have to work with the webhost for your change in connection strings, and migrating the sql data to their sql server. Best thing is to make a bak or get the mdb and ldb to them, however your permissions will be an issue on a hosted SQL.

As far as i know, there is no other quick way, aside for using Tek-Tips to walk you through your issues.

MSAccess CAN connect via a hosted sql, you will need to setup ODBC connection DSNs to that SQL on each computer connecting. And again in a hosted situation, table naming might get a little jarred, as when Access links a table to sql it will be in the dbo_tblname format. So Link the table and rename them to what your reports call, or rewrite your reports to use the table name Access wants to call it.