Connecting Dreamweaver to Access 2007 database

[Jedi7]

Hi, I am relatively new to Dreamweaver CS3; I have built a database in MS Access 2007; I'm looking to do either of the following;

1. Put the database form on the web, so users can enter information straight into the database or/
2. Create a front end form in Dreamweaver and link it to my database

Ideally, I would like to do #1

This is an internet website, not an intranet website.

Any help would be appreciated as I am growing frustrated.

Thanks,

Raymond!

[Newsgroup_User]

It's really the same thing .. you will either use a form you create to
access the database using access (which is really just a page) and that will
insert to the database, or you will create the page in DW and that will
insert to the same database.

The only real difference is that the latter will probably look better. :)


--
Nancy Gill
Adobe Community Expert
Author: Dreamweaver 8 e-book for the DMX Zone
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: Dreamweaver CS3: The Missing Manual,
DMX 2004: The Complete Reference, DMX 2004: A Beginner's Guide
Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"Jedi7" <webforumsuser@macromedia.com> wrote in message
news:fkbh48$aak$1@forums.macromedia.com...
> Hi, I am relatively new to Dreamweaver CS3; I have built a database in MS
> Access 2007; I'm looking to do either of the following;
>
> 1. Put the database form on the web, so users can enter information
> straight
> into the database or/
> 2. Create a front end form in Dreamweaver and link it to my database
>
> Ideally, I would like to do #1
>
> This is an internet website, not an intranet website.
>
> Any help would be appreciated as I am growing frustrated.
>
> Thanks,
>
> Raymond!
>

[Jedi7]

Thanks, Nancy, but do you know how I go about doing this? Step by step?

[delaneypub]

In Dreamweaver help, read the sections on Preparing to Build Dynamic sites, Making Pages Dynamic and Building Applications Visually. Those are the section titles for DW CS3, but previous versions should have similar sections.

[matthew stuart]

An excellent place to start is to buy a book, and it doesn't have to be a recent book because the process of connecting to an access db has remained the same for years.

You really need to decide which language to use. PHP, ASP or ColdFusion. I use ASP as at the time I started, the databasing side of dreamweaver was called drumbeat and that was purely ASP.

I guess ASP may be the easiest to learn because all you need to do is insert your windows XP disk an install IIS (Internet Information Services). This enables you to serve ASP pages locally for testing.

Very basically, for any language you need to allow privaledges on the folder the database is in, and then set up a connection to the db via DW. You then create a blank page and literally click a button that launches a wizard called 'Record Insertion Form Wizard' and within minutes, you have a page that inserts to your db.

Now, that is very basically explained, and when you know what you're doing, it takes less time to do than it did for me type this reply. However, learning it is a different kettle of fish which is why I say get a book. The current books seem to be mainly php with MySQL, but the older books seem to be ASP with Access or MySQL.

Try it with DW and if you get stuck, ask questions here. You pretty much always get the help you need. I reckon this is just about the best forum I have ever been on for responses.

Mat

[Newsgroup_User]

matthew stuart wrote:
> I guess ASP may be the easiest to learn because all you need to do is insert
> your windows XP disk an install IIS (Internet Information Services). This
> enables you to serve ASP pages locally for testing.

That makes ASP easy to install, but ease of installation does not
necessarily mean ease of learning.

> learning it
> is a different kettle of fish which is why I say get a book. The current books
> seem to be mainly php with MySQL, but the older books seem to be ASP with
> Access or MySQL.

There's a very good reason for that. Microsoft stopped developing ASP in
2000. Although ASP is widely supported, and will continue to be for the
foreseeable future, it's a technology that's going nowhere. Anyone just
starting out to learn how to build a database-driven website would be
better advised to learn one of the technologies that remain in active
development. That means ASP.NET - which has a steeper learning curve
than ASP - ColdFusion, or PHP.

Another important consideration is which database to use. Access is not
designed to be used on a website. It works fine for small websites that
don't get many visitors, but it creates bloated files, and locks up when
traffic increases. Although MySQL and Microsoft SQL Server are more
difficult to learn, they are a much better option for a website.

I'm biased in favour of PHP and MySQL because I write books about them,
but I would seriously advise Jedi7 to choose anything other than Access/ASP.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/