"Learn2010" wrote in message news:*** Email address is removed for privacy ***...
That's a killer for me? I have spoken to several people, some at Microsoft, and got the impression that once it was published to the web, it was a standalone program. My bad. From what I know, there is no other way to get it on the web. Is that true? Are there
any other options for an Access programmer that you know of?
When you publish to a web site, the result is a standalone program, but is no more standalone than any other web development you choose.
I mean if you develop your software using PHP, or python, and your web provider uses asp.net, then obviously your application is not going to work, is it?
And if you develop your application for the web using mySQL, and your current provider uses ms SQL server, then your application is not going to work is it?
And if you write some table logic and store procedures for oracle, and your current provider is ms-SQL, then again your application will not work.
So you'll have to explain what you mean by standalone?
As a general rule you need the follwing to build + setup a web system.
You first need a web server. There are many, but the most popular is Apache, and IIS (Microsoft Internet Services), but there are others from Sun, and IBM such as WebShere. They are all different, just like different operating systems on a computer. They
are not compatiable with each other.
You then need to choose a database server to store the table data. That data base server can be Oracle, MySql, MSQL, Access Web Services, Postgres, and again each is different, and you have to write everything to work with the particular database system
you choose.
You then need to adopt some programing language that the WEB Server (PROVIDER) supports (PHP, ASP.NET, python , Access Web Services etc.).
You then need to Adopt some programming language for the browser. (remember code that you write inside of an form has to run on your user's desktop inside of a web browser �?? if all code runs server side, then the application is slow since web system
respond quite slow �?? think of when you hit a button on a web site, it takes time to respond).
So what exactly system are you talking about that you know that will be stand alone in terms of having a web based database system in which the forms, code, data tables and database server all work together?
The adoption of your web based technologies is no different than the desktop, and access can no more run Foxpro code, then Foxpro can run access code. And the same thing goes for the web, if you develop using ms SQL server, and your web providers using
oracle or MySQL, your code and application is not going to run.
So you pretty much have to adopt 3 to 4 technologies here. You need some coding system that allows to build browser side code, usually JavaScript. You then need some type of database server to store your tables and data into. You then need some type of
web server to dish out web pages. And then you need some type of programming language to tie all three of the systems together.
So you better explain to be what you mean by standalone? There is no such system that doesn't have any database server and system to tie the web browser to the web server which in term is tied to the database server.
The great thing about access web services, is the browser code, the database engine code, the web server etc are all tied together for you into one coherent system. This means you don�??t have to learn three or four different web based development technologies
to make the whole mess all work together.
So you should clarify what you mean by standalone? What database server and web server and programming language are you taking about that results in such a stand alone system?
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
*** Email address is removed for privacy ***