Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 3rd, 2004, 06:54 PM
Authorized User
 
Join Date: Mar 2004
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default putting database on the web

does anyone have any links on putting an access database on the internet? is that what MySQL is for? I am confused, please help.

thanks

aCk!
__________________
aCk!
 
Old March 3rd, 2004, 07:52 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default

MySQL is an open source database application that is used for commercial websites that wish to create large databases for users to access over the web. Other such databases for this purpose include MS SQL Server, which is MS Access cousin by rights. These database are ideal for the web as they are server based and allow a number of users to access a database at the same time using scripting languages like PHP or Active Server Pages (ASP)

MS Access is a relational database application ideal for office based database applications whereby the number of users accessing the database at a particular time is limited. That said you can use a MS Access database with a website but I strongly advise you against it as the performance of the database will be poor and security risks high. If you wanted to use a MS Access database with your website you would have to access it using Active Server Pages. Which is a special scripting language used to connect to a database like Access over the Web

Gaz
 
Old March 3rd, 2004, 07:58 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default


On the other hand if your version of MS Access is 2002 (XP) there is a feature that allows you to save a form as a web page. Look under the FILE menu and select save as web page.

Should you be wanting to use Access as a database connected to a website using a scripting language like ASP , to get the best performance out of the database as soon as you open a connection close it as quickly as possible.


Gaz
 
Old March 4th, 2004, 12:27 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If it's links you want, it's links you'll get:

http://www.wrox.com/books/0764543636.shtml

http://www.wrox.com/books/076454375X.shtml

http://www.wrox.com/books/0764557440.shtml


In short, there's various ways to "put databases on the web" - from XML to ASP to Java to static HTML to PHP to ColdFusion and many more.


I am a loud man with a very large hat. This means I am in charge
 
Old March 8th, 2004, 01:21 PM
Registered User
 
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have all of my Access 2K application written with Access forms (list boxes, controls, etc.), and the database is stored on a Server out on the internet. I get to this database with an ODBC and an ADODB.connection.

My question: the connection always seems to be slow. It takes several seconds to get back the information, even though I only have a tiny, tiny database (information on about 25 clients). Is there a faster way I should be doing this?

 
Old March 8th, 2004, 03:26 PM
Friend of Wrox
 
Join Date: Aug 2003
Posts: 137
Thanks: 0
Thanked 0 Times in 0 Posts
Default


I suspect it's just Access being Access. Remember it isn't really for the web but can be used for databases of the size you stated. The connection you are using is correct.

The only thing I can recommend is to only establish a connection at the very last minute and then once the data has been retrieved close the connection again.

Gaz
 
Old March 8th, 2004, 04:14 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I agree with Gaz.
However, if your web server can be accessed over your LAN, it might speed things up if you connect to it via your LAN rather than over http.
For example, rather than having your ADODB connections point to http://127.0.0.1/DBFolder have them point to \\WebServer\DBFolder

HTH

Steven

I am a loud man with a very large hat. This means I am in charge
 
Old March 9th, 2004, 09:23 AM
Registered User
 
Join Date: Mar 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thank you for your input. O.K., so I'm stuck with the speed if I stay with Access. I've spent too much time creating the custom forms and VBA codes to abandon it, but I'm seeing things about ASP and converting Access to ASP. Are there any other vehicles I could use that would be practical for me to consider, and would they make any difference? The thing that got me started thinking about all this is that I've written some PERL webpages with MySQL, and this goofy little database runs much faster.






Similar Threads
Thread Thread Starter Forum Replies Last Post
web database harrysingh26 Classic ASP Databases 0 October 3rd, 2005 11:43 PM
Putting it all together lincsimp XSLT 1 August 22nd, 2005 08:49 AM
Putting connection in web.config issue mar0364 ASP.NET 1.0 and 1.1 Basics 7 October 20th, 2004 06:59 AM
putting it another way MetsFan BOOK: Professional Crystal Reports for VS.NET 1 June 4th, 2004 12:12 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.