SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Sep 2001
    Location
    Portland, OR
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    how to access MS Access?

    i was just wondering:

    i have been presented with the task of creating a database-driven website for which all of the data currently resides in MS Access. what i want to know is, how should i go about connecting to the database from the website? do i have to learn asp to do this? or is it possible to somehow use perl (which i already sort of know)? or is it better to put the data into a different database program? i don't really know anything about Access so any help would be massively appreciated.

    TIA,
    sadie

  2. #2
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Access is OK for a (relatively) small amount of users and data. Once your database is over a few 100 MB it may be time look at other platforms. From Access, the upgrade to SQL Server is fairly seamless, and SQL Server will scale right up to huge amounts of traffic and data.

    Access is also not great in a replicated environment (where you have databases distributed across a number of servers).

    In terms of getting the data out onto a webpage, you could use ASP, ColdFusion, or probably even PHP. PHP would be the most suitable if you're familiar with Perl.

    You could also use Perl I guess (Perl can do anything, right?) But I don't know exactly how this might be done.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  3. #3
    epsilon transition cupid's Avatar
    Join Date
    Aug 2001
    Location
    Kent, Ohio
    Posts
    367
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Create a dsn for your access file (this is done on the webserver.. you may have to contact the host), then it's just a matter of choosing a language. Cold Fusion is probably the easiest way to go... but it costs money. With perl, you'd have to use the dbi functionalities. With php, use the odbc functions.

    Sorry about the broad overview, but this is a pretty general subject

  4. #4
    SitePoint Enthusiast
    Join Date
    Sep 2001
    Location
    Portland, OR
    Posts
    32
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    thanks for the info, that is exactly what i needed to know. hopefully i will be able to convince my supervisor to use SQL server instead of access...

  5. #5
    SitePoint Addict
    Join Date
    Dec 2000
    Location
    Orange County, Ca
    Posts
    288
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    sadielane,

    I know this response is a little old, but if you still need to connect to an Access database via Perl, check out this article:
    http://wdvl.internet.com/Authoring/L...eb/index6.html

    I hope this helps.
    Wordpress Auto Installer
    www.webproco.com


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •