SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Enthusiast lalewicz's Avatar
    Join Date
    Jun 2003
    Location
    Howell, MI - US
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Best way to deal with 2 data bases

    I was wondering.............

    I have a client that has information in an access database.

    They want to get more of the same from web users.

    I am not skilled in getting data from the web into a local database, I usually use sql and just deal with online data. If I download it, I get it in a csv file and it ends up in Excel.

    Should I go with sql and if so how do I get it so that I can smush it into an access table?

    Should I use a copy of their existing database and have the asp pages work off of that?

    If so is there anything I should be aware of when using access on the web?

    Thank you in advance.

  2. #2
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If your user load is relatively low, then there is absolutely no reason not to use your Access database online...

  3. #3
    SitePoint Enthusiast lalewicz's Avatar
    Join Date
    Jun 2003
    Location
    Howell, MI - US
    Posts
    53
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    So you think I should just take that mdb file and stick it up there?

    I suppose I can let front page make the data connection.

    ??

  4. #4
    Drupaler bronze trophy greg.harvey's Avatar
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    3,258
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    As long as your hosting company allows you to set up ODBC connections you can just host your MDB file somewhere on the server (outside the wwwroot) and connect to it direct.

    As I say though, only if your likely number of users isn't very high. MDBs are great for small scale stuff but they just slow to a crawl if they get too much traffic.

    G


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
  •