Hi Finn,
For performance with large scale applications SQL Server is the route to
go. However, it's more expensive than Access. I would recommend that you
test deploy with Access as your backend. And as the need arises migrate to
SQL Server (pretty straight-forward in most cases).
As for the price of Dev tool if developing Data Access Pages then all you
need from the developer side is Office Developer (I take it your ISP will
have the backend technology).
If doing ASP.Net (the latest technology) then you would want Visual Studio
NET (for cost see:
http://msdn.microsoft.com/vstudio/howtobuy/pricing.aspx)
Not sure about non-Microsoft developer tools.
DAPs use Office Web Components (OWC) which are loaded on the clients
machine. One of the drawbacks to using DAPs is that the client machine
must support OWC. I believe that eliminates MAC users and Linux (i think).
If you are looking for your web app to reach a broad range of users (not
requiring OWC) then yes ASP.Net is the route to go. Larger learning curve
but worth the effort.
Regards,
Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<
http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <
http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."
This posting is provided "AS IS" with no warranties, and confers no rights
--------------------
| Content-Class: urn:content-classes:message
| From: <
[email protected]>
| Sender: <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Sharing data on the internet?
| Date: Tue, 16 Mar 2004 08:26:59 -0800
| Lines: 107
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQLc4E8IBt1FzMOTIaemS5oebMePg==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:77183
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| Hej Eric
| Thanks for your answer
| As I see it, you propose two ways to go - which one will
| depend on
| - performance - it will have to run on 256kb lines.
| - how easy to convert
| - price of dev-tool(I already have 2000 office developer)
| - future maintenance
| Just to make sure, I understand things right:
| Does the DAP and Access/MSSQL back-end mean, that there
| will be some sort of 'frontend-client' running on the
| users pc and database on the server ?
| The ASP.NET & Access/MSSQL is a solution, that runs only
| on the web-server, and the users access the application
| through a browser?
|
| Best regards
| Finn
| >-----Original Message-----
| >Hi Finn,
| >
| >If you are needing to deploy your application over the
| Internet and you are
| >looking to use Microsoft Access technologies then you
| would use Data Access
| >Pages. See: How To: Deploy Data Access Pages over the
| Internet
| >
http://support.microsoft.com/default.aspx?scid=kb;en-
| us;291783
| >
| >If you are looking to expand beyond Microsoft Access then
| you could develop
| >ASP / ASP.net pages, or other web solutions using Access
| or SQL Server as
| >your backend database.
| >
| >I hope this helps! If you have additional questions on
| this topic, please
| >respond back to this posting.
| >
| >
| >Regards,
| >
| >Eric Butts
| >Microsoft Access Support
| >
[email protected]
| >"Microsoft Security Announcement: Have you installed the
| patch for
| >Microsoft Security Bulletin MS03-026? If not Microsoft
| strongly advises
| >you to review the information at the following link
| regarding Microsoft
| >Security Bulletin MS03-026
| ><
http://www.microsoft.com/security/security_bulletins/ms03
| -026.asp> and/or
| >to visit Windows Update at
| <
http://windowsupdate.microsoft.com/> to install
| >the patch. Running the SCAN program from the Windows
| Update site will help
| >to insure you are current with all security patches, not
| just MS03-026."
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights
| >
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Finn" <
[email protected]>
| >| Sender: "Finn" <
[email protected]>
| >| Subject: Sharing data on the internet?
| >| Date: Sat, 13 Mar 2004 06:48:39 -0800
| >| Lines: 14
| >| Message-ID: <
[email protected]>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Thread-Index: AcQJCkXOTGnMjJ5vR2ia0IcTMdoLLg==
| >| Newsgroups: microsoft.public.access.tablesdbdesign
| >| Path: cpmsftngxa06.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| microsoft.public.access.tablesdbdesign:77099
| >| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| >| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
| >|
| >| I have developed a database application in Access 2000.
| >| Until now it has been running on stand-alone pc's, as
| the
| >| users are not connected to a LAN.
| >| Now a multiuser environment is asked for. The users all
| >| have access to the internet.
| >| Can I:
| >| Put the db on a Web-server?
| >| Have a front-end client on the pc, and the back-end on
| the
| >| web-server?
| >| MSSQL-server ? Data Access Pages ?
| >|
| >| Ideas are very welcome - thanks
| >|
| >| Finn
| >|
| >
| >.
| >
|
