I am using Access97. Currently, th

[ruthcali]

I am using Access97. Currently, the database is a .mde and is on our Novell network and is using Windows 98.

I have a Windows NT server with SQL server 6.5 on it that the database will be moving to. (I don't know anything about Windows NT or SQL Server, though).

How can i go about putting my database on the web? I need dynamic pages that can be queried.

I am at a loss of where to start.

Any help will be greatly appreciated.

Thanks,
Ruth

ruth.jonkman@wcom.com

 

[jimmythegeek]

First of all, is it possible for you to upgrade to SQL Server 7.0 at least. SQL Server 2000 has just come out, so you will be using a version that is fairly old in the industry.

Secondly, since you are using NT, and SQL Server, then you will most likely be using Active Server Pages (ASP's), and ADO (ActiveX Data Objecs) to retreive your data. This is Microsoft's technology, so would be the logical choice.

ASP technology is quite different than Access or VB programming. You have to learn HTML, ASP, ADO, and VB Script, which a scaled down version of Visual Basic.

Active Server Pages will communicate (via ADO) with your SQL Server database. You will also need IIS (Internet Information Server) running on your NT Server.

If this is not enough to make your head spin, then try this; when you code your web pages, Netscape, and Internet Explorer handle it differently. So just when you think you have your web page working perfectly, go try it in the other browser, and alot of times it won't work.

Web development can be very frustrating because of all the technologies you have to learn, and the fact that cross-browser coding is difficult at best.

The other option is to use Java. This is a whole seperate language than anything like VB.

Either way you go, if you are trying to learn from scratch, I would suggest finding someone experienced in web developmnet to mentor you through it, or you could be spending alot of long nights banging your head against a wall.

Good Luck Jim Lunde
compugeeks@hotmail.com
Custom Application Development

 

[ruthcali]

Jim,

Would you like to be my mentor? I have a fragile head. ruth.jonkman@wcom.com