×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Dreamweaver & Flash

How to connect DW & Access Databases - Getting Started by schase
Posted: 31 Oct 02

First off - if your database that your needing to view/modify records from is called say MMDB.mdb

Than you as the designer can set one up on your local machine by hitting the modify menu in DW, connections, this pops up a box - hit new - Data Source Name,
this pops up another box - hit define button.  This pops up the systems ODBC Data Source Administrator box.

System DSN tab - hit add.  If it is MS Access - select Microsoft Access Driver - *.mdb, click Finish, this pops up yet another box.

Here you type the DSN name, description and select the database.

Which if your database is called MMDB.mdb, you put for Data Source Name, MMDB, description - anything.  Select teh database.  hit ok. OK again to close the ODBC box, brings you back to DW's DSN list - type in Connection name
MMDB

Data Source Name drop down - pick MMDB from the list.

Hit ok,
closes that box - to the connections list.  hit Done.


Now your DSN is set up.

DSN-less is another method we can also cover.

For your sys admin - they set one up the same way - you upload your database to a folder that they will give ISUSR read/write permissions too - and they can goto ODBC usually through Administrative Tools (or control panel).

But either way you have to upload the database to a folder that has read/write permissions.

Most websites follow a standart layout.

like lets say your website is on the D Drive.

D:\

D:\myweb\

then there are usually 3 folders

D:\myweb\htdocs (or html)
D:\myweb\logs
D:\myweb\private (or database)

inside the htdocs (or html) is usually the one webmasters see the most - here goes all html files - and any subfolders used in your website structure.

databases go inside the private (or database) folder.  It is outside IIS's "home path" where a browser would goto.  Little added security.

Thats it - your connected and can begin making dynamic content!

Best Wishes

Back to Adobe FAQ Index
Back to Adobe Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close