|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
12-08-2001, 04:50 AM
|
#1 |
|
Member (6 bit)
Join Date: Dec 2001
Location: Charlotte, NC
Posts: 34
|
I need help on connecting Access on the internet
I want to create a data base on my home PC for a web site and I am using access. Is there a way to connect my data base to the web site, how can i do that.. I am new on this... any help would be appreciated.
|
|
|
|
12-11-2001, 06:04 AM
|
#2 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Birmingham, UK.
Posts: 553
 |
Firstly to access a database you need to use a server side language such as php, asp or cgi.
The database must also be stored on the server this can be done by uploading it much the same as uploading pages. First thing to check is what server side language support your web host offers and if they support databases (find out which ones). I'm sure the other guys can suggest some good web hosts. |
|
|
|
|
12-11-2001, 07:58 PM
|
#3 |
|
Staff
Premium Member
Join Date: Jul 1999
Location: Arlington, TN
Posts: 5,538
|
Access is not a good web database since it bombs out after about 20 connections. I would recommend MySQL instead, which is on nearly all 'Nix' based hosts. If you use Access, you also limit yourself to Windows hosts.
__________________
Want to Make $$$$ with your Computer? No Risk! Simply press shift-4 four times in a row |
|
|
|
|
12-12-2001, 03:22 AM
|
#4 |
|
Member (10 bit)
Join Date: Jan 2001
Location: Birmingham, UK.
Posts: 553
|
You are quite right mairving that Access isn't the best web database but then again it depends what he is using it for. If the number of users hitting the database is going to be low then Access should cope (I'm pretty sure Access can only cope with 10 simultaneous connections).
But I completely agree that MySQL is alot more scalable if he needs it plus of course you can assume better security for the data. Also I have found MySQL seems to be used very wide spread by Unix and windows hosts. |
|
|
|
|
12-12-2001, 10:11 AM
|
#5 |
|
Member (9 bit)
Join Date: May 2000
Location: Lexington, Michigan
Posts: 353
|
since you already have access, the eaisest way for you to connect it to the
web is to get a copy of frontpage 2000 or higher. frontpage has built-in connectivity for connecting to a access database from a web page. obviously your not building an e-commerce type product that would require an sql type database and the associated programming, so for some light-weight database connectivity access will be fine.
__________________
Certifiable =========================================== Cisco CCNA,CCDA CompTIA A+, Network+,Inet+,Security+ CIW Associate IBM AIX certified IBM Certified Specialist - p5 and pSeries Administration and Support for AIX 5L V5.3 IBM Certified Systems Expert - p5 and pSeries Enterprise Technical Support AIX 5L V5.3 |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
