Moving access database online

Discussion in 'Databases' started by Matt18, Jan 16, 2011.

  1. #1
    Hi

    I am quite a n00b when it comes to databases but I know how to use MS Access. I am starting a small business and would need some help with creating a database online.

    I do not know any script language, so I would need to like export Access database and import it to something online. Then have a "website" which would serve like a "Database manager" and would have similar functions to Access.

    How would be the best way to start with this?

    Thanks alot for your help :)
     
    Matt18, Jan 16, 2011 IP
  2. EvanP

    EvanP Banned

    Messages:
    1,731
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #2
    MySQL database would probably be your best option... And then editing it through phpMyAdmin. It's not that hard and once you've learnt it you can make edits in seconds. Google it to find out more. :)
     
    EvanP, Jan 16, 2011 IP
  3. AstarothSolutions

    AstarothSolutions Peon

    Messages:
    2,680
    Likes Received:
    77
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Which functions of Access are you looking at? Reports & forms or just tables and views?

    Ms SQL Express and MySQL are both free and both have free administration tools but neither are really as "complete" as Access if you wanting to output reports from it (rather than just CSVs) or generate input forms etc.

    Depending on the complexity of what you need it may be best to either learn something to create a front end (PHP or .Net - the latter has free drag and drop type of development application) or pay someone to build it in the first place and then learn as you go along to maintain it.
     
    AstarothSolutions, Jan 16, 2011 IP
  4. dgiles79

    dgiles79 Peon

    Messages:
    32
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    It may not be exactly what you are looking for, but Microsoft is releasing Office 365 soon, and I believe that allows Access to be used and updated through an online interface. That way you wouldn't need to learn a new system.
     
    dgiles79, Jan 17, 2011 IP
  5. Matt18

    Matt18 Guest

    Messages:
    591
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    thank you all. I have tries many of these already.

    Is release date of Office 365 already known? This seems as a perfect solution!
     
    Matt18, Jan 18, 2011 IP
  6. asdirc

    asdirc Active Member

    Messages:
    275
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #6
    try to export your database from access in cvs format and import it in mysql with help of phpmyadmin that you ll find in your cpanel admin section of your site.
     
    asdirc, Jan 19, 2011 IP
  7. Matt18

    Matt18 Guest

    Messages:
    591
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    I am now testing out navicat in combination with mysql database

    Do you know of anything similar to navicat that is opensource maybe?
     
    Matt18, Jan 19, 2011 IP
  8. joshua_

    joshua_ Peon

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #8
    I don't have a ton of MySQL experience (I prefer MSSQL), however I would recommend using MySQL Workbench in combination with MySQL for your database admin needs. Workbench is free and can do a lot of stuff through a sleek, fast, easy-to-use GUI (unlike phpmyadmin). You can get server logs and and performance reports, edit users and relationships using graphic references, populate data similar to how you would in MS Access, etc.

    On a side note, if you're interested in Microsoft's platform you can always consider using ASP.NET/MSSQL. They have a brilliant feature called gridview that lets you sort and edit records in your database from a web interface that you can custom design using C# or VB. There are tons of tutorials on the internet, I suggest checking it out.
     
    joshua_, Jan 25, 2011 IP
  9. graformix

    graformix Member

    Messages:
    92
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #9
    Try conversion tools from the link in my signature.
     
    graformix, Jan 27, 2011 IP
  10. godloves

    godloves Peon

    Messages:
    48
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    basic thing is you have to learn ms access.
     
    godloves, Jan 28, 2011 IP
  11. sanchyclub

    sanchyclub Well-Known Member

    Messages:
    625
    Likes Received:
    6
    Best Answers:
    2
    Trophy Points:
    105
    #11
    If you can do something with mysql then it will be much better. otherwise you can check sql server
    both are good for online database.
     
    sanchyclub, Feb 22, 2011 IP
  12. prptl709

    prptl709 Guest

    Messages:
    83
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #12
    Accessing the database online means what? We have to use database manager for that.
     
    prptl709, Feb 23, 2011 IP