simple web applications

[tom4038]

ive got an ms access application i want on the web, whats the quickest way to do it.

been googling and found this http://creator.zoho.com/ has anyone used it or something similar. havent got a budget in mind so 2 users for free seemed a good deal!

i just want a few quieries and the ability to download pdf reports on demand, i also have a copy of dreamweaver and some limited experiance with webpages in dreamweaver but not databases!

 

[HiTechCoach]

ive got an ms access application i want on the web, whats the quickest way to do it.

Access can not be used across the internet.

You can use:

1) Use a Terminal Server or VNC to run a remote session onb a computer with Access.

2) Use a RDBMS such as MySQL, Oracle, SQL Server, PostgreSQL that has a robust client library for remote access on a web server connected to the internet;

-- a) Connect to the database using an remote Access front end is quite an excellent front-end client and works well with any of those.

-- b) recreate the application in a web based scripting languages. It may be possible to use an Access database for the back end (tables) only based on which web server you are using.


Note: There are also many other posts here at AWF on this subject.

 

[tom4038]

Access can not be used across the internet.

You can use:

1) Use a Terminal Server or VNC to run a remote session onb a computer with Access.

2) Use a RDBMS such as MySQL, Oracle, SQL Server, PostgreSQL that has a robust client library for remote access on a web server connected to the internet;

-- a) Connect to the database using an remote Access front end is quite an excellent front-end client and works well with any of those.

-- b) recreate the application in a web based scripting languages. It may be possible to use an Access database for the back end (tables) only based on which web server you are using.


Note: There are also many other posts here at AWF on this subject.

out of interest what kind of costs are associated with the solutions above, also which is the quickest route with the least experiance?

 

[Simon_MT]

When you think about, the web is obstentsibly a text environment. A database is an indexing system with data. To say not to use Access as a database is not accurate. Oracle and SQL server are more sophisticated but what do really want out of your web site. I have driven a web site supporting 16,500 images taking up more than 650MB using a 7MB Access 97 database. The point about designing web sites is the amount of information being rendered. Invariably the data is rendered first as opposed to any images.

I have used IIS to version 6 and I can tell you Access databases work. To say "production quality" only use SQL server, the role of underlying database is just to present data, it is what you do within the web pages that really matters.

Reliability is a function of the web hosting environment, the hosting sites ability to prevent DoS that bring down the hosting site. There is nothing inherent within Access that will affect reliability.

Simon

 

[boblarson]

For performance and reliability reasons, please avoid using MS Access databases for production-quality Web applications. IIS has been extensively tested and is designed to work with Microsoft SQL Server, thus we suggest you to use MS SQL Server as well.

So, the questions to this statement has to be -

1. Who are you and have you used Access?

2. Where does the "authoritative" view come from and why is it said in such a tone to imply authoritative input.

3. You've 5 posts on this forum. We don't know you at this point and how are we to know you know what you are talking about? You've provided no supporting evidence, just a single statement which says "don't do it."

I'm with Simon on this.

 

[CraigDolphin]

Out of curiosity, how would one go about linking a local Access frontend with a web-server running mysql with the backend database online?

 

[Simon_MT]

There are performance issues as opposed to a Terminal Server solution which simply transmits the screen dumps from a local sourced data source and database over the WAN.

Simon

 

[tom4038]

ok thanks for everyones input, but sorry if im asking the question all over again but...

whats going to be the quickest way to get this out on the web within subscribing to an addtional service? I just want to display the results of a few queries! nothin fancy!

i have a adobe dreamweaver cs3 if that would be of any use too, thanks

ps. to note, years ago i worked for a copy whom used ms access, point being i am happy to use access, sure if i had a few hundred users and 1000's and 1000's of records i might concider another route but current db would have less than five users and on average adds aprrox 600 records per month... im more than happy at this level.

anyway rant over ? about simple web app still stands, sorry to ask again, im just web / access challenged!