Training options

[hockeylvr]

I currently am working with Access 2000 and learning ASP and HTML, ADO and Visual Basic. My goal is to create dynamic web pages to be placed on our intranet for about 30-40 employees to use to query/add/delete information.
My question, what is the best/correct way to make this happen?

Do I store the data in an Access table and use Visual Basic to create a user interface? Will I need to use ASP to pull the data through the web pages? There will be 2000+ records and will grow considerably. Should I think about a different database - MySQL perhaps? I've read about all of these but am confusing myself as to how they all tie in together.

I appreciate any help you could give me!

Thanks,

Toni

 

[onpnt]

Will I need to use ASP to pull the data through the web pages?

Yes, but not limited to ASP. Any server technology will work.

Should I think about a different database - MySQL perhaps?

Absolutely! Access is a desktop DB and is not meant to hold vast amounts of data.

As far as VB comes in, there is no real reason for it's use in something like this. ASP/DB is the perfect combo for you with such a limited sounding process. What server are you going to run etc..

also, you can ask more specific workflow and syntax questions in the forums in which you respectfully mean to use
eg:
ASP : Forum333
PHP : Forum434
IIS : Forum41
HTML/CSS : Forum215
and on...

_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[hockeylvr]

Thanks for the info onpnt,

So, looks like I will:

Create my tables with MySQL
Use ASP/HTML to connect to the db and as the user interface on the intranet website.

At what point/what type of applications would you suggest VB or VB.Net?

Toni

 

[onpnt]

Yes, that is correct

VB.NET can be integrated into ASP.NET to create intranet applications for you but I don't see much resource needed from VB as far as web interfaces go.



_____________________________________________________________________
_{You can accomplish anything in life, provided that you do not mind who gets credit.
Harry S. Truman}

http://www.onpntwebdesigns.com

 

[hockeylvr]

Thanks for all of your help, it now makes a lot more sense to me. I think I'll wait a couple of months before I tackle a VB project.

Toni