How to Create Online Database?

[Asle]

Hi All,

I would like to create online Quote database for my company.

I have some knowledge about Ms Access/VBA but i have never ever created an online database.

the main purpose is, i want the customers to create a Quote from our company website and i would like to keep track of all the Quotes.

i dunno how to do this? i mean, should i create in MySQL and connect with PHP or create database in MS Access with ASP??

I am new to scripting languages and i will be more then happy if someone could tell me where i can find necessary articles to create an online database?

thanks n regards,
Asle

[PianoMan64]

Well, I have a few questions first before I would be able to begin to answer this question.

1. Do you have your own server, or are you going to be hosting the pages on a web hosting service?

2. How many users/Quotes do you think you would be doing at any given time during the day?

3. Do you expect to increase the number of users doing online quotes as times go on? say more than 10 a day?

4. How much experience do you have in coding in ASP or VBA for that matter?

Let me know what the answer to these questions are, then we can at least move forward from there.

Joe P.

[missinglinq]

Also, your line " I have some knowledge about Ms Access/VBA but i have never ever created an online database." is somewhat ambiguous! Have you, in fact, ever created any databases?

Linq ;0)>

[Asle]

thanks for ur reply Joe.

1. I am going to be hosting the pages on a web hosting service


2. Approximately, 5 - 10 users would create/process the quotes at a particular time.

3. in the future, say few months down the line, the number of users will b more than 10.

4. i know VBA but no experience in ASP... i will try to learn if that is wat needed to get this done.

To missingling :
if i have not created any databases, i would not have said that i hav knowledge in ms access/ vba... having said that, i hav not tried to access the database through a website.

chuz,
Asle

[PianoMan64]

The easiest way that I can tell you to create a Ms access database with webpages would be to get a copy of either FrontPage 2003 or Experesions Web, which is the lates version of FrontPage. This will allow you to create a database connection. then when you go to publish your web pages, that this will retain the connection for you. If you want to go as far as learning ASP, then you're going to have to learn that as well if you're going to want to manipulate any of the data objects on the form, as well as be able to create your own connections to additional data sources.

I would get my hands on an old book of ASP, as well as maybe even Java, since that seems to be a little more accepted platform than ASP. ASP requires a Windows OS, where as Java, can run on either WIndows or Linux Server.

Hope that helps,

Joe P.

[Asle]

thanks a lot for ur response, Joe.

you have clearly stated what i have 2 do now...

i will try 2 learn ASP and FrontPage.... hope it is easy 2 learn .. lol..

thanks again

Asle

[missinglinq]

No offense intended, Asle! A lot of people get stuck maintaining/modifying existing databases, and have "some knowledge about Ms Access/VBA" without ever having actually created a database. I was just trying to get a little more information on your skill level in order for us to better advise you!

I've never dealt with a web-based db, but from what I've seen here and on the other four or five Access forums I frequent, ASP is the language of preference for doing this with Access. Both ASP and Java will have a fairly large learning curve, I expect. You might want to post a thread here on our forums covering these subjects to see what the experts there have to say.

Good luck with your project!

Linq ;0)>

[Asle]

thanks for your reply, Linq.

I am gonna learn ASP after work and lets see how far i go...

I gotta finish other works in the mean time before this project

take care

chuz,
Asle