Lost in Translation...

They have: 1 posts

Joined: Dec 2005

Hello All,

I need some assistance from the wizened veterans here. Confused

I have used FrontPage for over 6 years. I recently bought Dreamweaver, and I'm trying to make the jump to using a database in some of my web sites. I have just bought XP Professional and Microsoft Access to have at my disposal, and I am slowly fumbling my way into creating a database(s) that will contain the information I need.

I'll tell you what I'm trying to accomplish and maybe you can tell me the easiest way to get there. I don't know programming and code, which is causing me much grief. I've bought several books in the last 2 weeks, for Java, Javascript, Access, Dreamweaver, XML, and none of them is helping to spell out for a layman what I'm trying to do. I'm about to move my webs sites from a server with a Linux platform to a windows platform with FrontPage extensions. My new hosting company says it will support the following:

"Our Windows based servers run Microsoft Windows 2003 as their operating system and do allow for ASP and ASP.NET scripting as well as Perl, PHP and CGI. We also offer MDSE data hosting with the ASP.NET platform. And we can install the ASP.NET starter kits upon request at no extra charge. "

I have a few mortgage web sites. I want to be able to create a database of lenders that has basic contact information about them that can then be dynamically displayed on my home page for site visitors. Going a step further, I want the lenders to have the ability to login in with a password through a browser and update any of their information without having access to the other lenders info on the site and have it update real time; with the lender with the most recent information displaying first, the second most recent next, etc.

Needless to say, I am completely lost. Coming from a WYSIWYG backround, trying to decipher all this programming is impossible. I was so frustrated yesterday I almost gave up. The books I have are very general about setting up local servers, setting up a DSN, loading scripts, etc.

Can anyone give me some pointers if there is a simple way I can teach myself how to do this? I don't have the resources to hire a database programmer. I thought setting this information to display in my web sites would be easier but I'm in completely over my head.

Is there a way to do what I'm looking for with just FrontPage, MS Access, and Dreamweaver?

Thanks in advance for your time.

Scott

chrishirst's picture

He has: 379 posts

Joined: Apr 2005

There are some basic database examples at http://www.asp101.com/samples/ both ASP and .net to get you started.

demonhale's picture

He has: 3,278 posts

Joined: May 2005

Also I read something about saving options in MSAccess and MSExcel allowing you to make databases that can be used in the Web. so it can be done, you just need to read on to some help files of your software while looking for some tutorials on the web. It takes time to do what you intend to do...

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.