ACCESS Coding no idea where to start....

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

ACCESS Coding no idea where to start....

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> ACCESS Coding no idea where to start....

Page: [1]


targetpractice2 Posts: 2 Joined: 8/31/2005 Status: offline	ACCESS Coding no idea where to start.... - 8/31/2005 6:53:04 Hi, This forum has the most comprehensive pages to find most things about Frontpage which is great but I want to dip my toe in the water and get some direction... I have created a Frontpage Website and got myself a Windows server host running FP / ODBC and ASP.NET. Idea behind website is private homesales... It has MYSQL running as the database on it but I do have MS ACCESS. I need to build a database to control all the house criteria (no. beds/baths price etc) and display on my website searchable by dropdowns etc. My problem is ive done the easy bit...(Frontpage website construction) but now the hard bit I have no idea where to start to link a DB. I can create the database in access easily enough and I GUESS that I just copy it over to my server if I want to use the Acces DB, but running queries is a night mare and in the end they should be run from the website anyway. It appears I will probably need to have some sort of SQL/VB programming done to the site but I am a complete beginner. After all that...apart from this great forum is there any good books/sites that I can look at that can take me through step by step how I do simple queries on ACCESS or should I use the MYSQL DB. For instance, I want users to input a postcode into my website which checks that I cover their area and displays a message back to them. Infact it must be the easiest thing to do because its two tables 1 with postcodes and 1 with the response .. and basically states YES I do and NO I dont... Thanks to whoever replies ..for just replying


Spooky Posts: 26618 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: ACCESS Coding no idea where to start.... - 8/31/2005 10:32:06 It sounds like you have everything you need to get started! With frontpage, it has something called the "DRW" (insert > database > results) that enables you to display the results of an access database. Check out www.outfront.net/spooky for more detail on that and see where you need to go to from there? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to targetpractice2)


targetpractice2 Posts: 2 Joined: 8/31/2005 Status: offline	RE: ACCESS Coding no idea where to start.... - 9/1/2005 4:42:31 Thanks Spooky, I have read many of your replies and advice you give to everyone on the forum, and you are doing a fantastic job for what in effect is a free advice service. Many thanks for taking the time to reply. TP. (in reply to Spooky)