CAN i use Access as a database in my website?

Discussion in 'MySQL' started by kk22bbme, Aug 30, 2006.

0
  1. #1
    CAN i use Access as a database in my website?

    Is it possible?....will the web hosting company approve that?:confused:
     
    kk22bbme, Aug 30, 2006 IP
  2. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Why would you want to? Just export it to a csv and upload it to sql.
     
    mad4, Aug 30, 2006 IP
  3. kk22bbme

    kk22bbme Peon

    Messages:
    125
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #3
    what is csv?
     
    kk22bbme, Aug 30, 2006 IP
  4. kk22bbme

    kk22bbme Peon

    Messages:
    125
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #4
    what is csv?..can you explain how...and how to upload sql?...
     
    kk22bbme, Aug 30, 2006 IP
  5. Keith_W.

    Keith_W. Peon

    Messages:
    29
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Sure, as long as you can MAP the Access db file.
     
    Keith_W., Aug 30, 2006 IP
  6. mad4

    mad4 Peon

    Messages:
    6,986
    Likes Received:
    493
    Best Answers:
    0
    Trophy Points:
    0
    #6
    CSV is a comma seperated value file.
    Does your host use MYSQL? Is is a php host or an asp host?
     
    mad4, Aug 31, 2006 IP
  7. pangea

    pangea Guest

    Messages:
    557
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    0
    #7
    you could use access as long as you can create db connections
     
    pangea, Aug 31, 2006 IP
  8. phd

    phd Active Member

    Messages:
    496
    Likes Received:
    14
    Best Answers:
    0
    Trophy Points:
    60
    #8
    Is your server is Linux or Windows?
     
    phd, Sep 1, 2006 IP
  9. kk22bbme

    kk22bbme Peon

    Messages:
    125
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #9
    I think it is a windows server
     
    kk22bbme, Sep 1, 2006 IP
  10. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #10
    You might have MS SQL if you got a windows server. If so that would be the best bet. If you don't - sure Access is fine (I just hope you don't expect a lot of traffic). Access is a solid database but is slow(ish) and can only accept about 10 concurrent users at a time. My advise, all your db-driven pages - before the page loads, hit the DB, Grab the data, and Close your DB connection. you can do this with the ASP function GetRows - which creates a 2dim array of your records. The faster you can get in to the DB, get your data, and get out the better.

    And by god - make sure you close your Access DB connections or you will get errors constantly because of the DB being opened too many times ;)
     
    ccoonen, Sep 7, 2006 IP
  11. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #11
    A quick side-note, if its a cheap ass hosting plan your on then i would not expect SQL server. it's a mighty large chunk o' change for a MS Sql Server license. But... maybe you got lucky :)
     
    ccoonen, Sep 7, 2006 IP
  12. VONRAT

    VONRAT Banned

    Messages:
    181
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #12
    right ... also .. last time i tried that .. i cant make it work if the access db is relational :D hope it works for you
     
    VONRAT, Sep 13, 2006 IP
  13. Froggie

    Froggie Well-Known Member

    Messages:
    665
    Likes Received:
    28
    Best Answers:
    0
    Trophy Points:
    120
    #13
    ask your host toassis you
    ifyour host dont assist you with this, change hosts (assist you with giving you access to that file)
     
    Froggie, Sep 13, 2006 IP
  14. Davidf25sc

    Davidf25sc Active Member

    Messages:
    165
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    53
    #14
    You can use access as database, but your server has to support it, you could ask them about it, but if i where you i would use mysql instead.
     
    Davidf25sc, Sep 15, 2006 IP
  15. intoex

    intoex Peon

    Messages:
    414
    Likes Received:
    7
    Best Answers:
    0
    Trophy Points:
    0
    #15
    I was working with MS Access, but not as base for web-application, I used it with Win32 application. For standalone application for windows I think it's best simple/effective solution. For web-application - hm, i think it's' sux. If you will have often record updates, deleting, many visitors - your database will grow and grow up. Better use MSQL server, or Mysql. In this case you will need to migrate data from access. But it's easy to do, if write little script or use comma separated files (.csv)
     
    intoex, Sep 20, 2006 IP