Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

help converting mySQL to access

  • 25-01-2007 1:39pm
    #1
    whiteshadow
    Registered Users, Registered Users 2 Posts: 771 ✭✭✭


    Ive developed a site in ASP with a mySQL back end.

    Im migrating the site to the new server only to find out they dont support mySQL on their windows servers and only support MS Access.

    So i need to convert my mySQL database into ACCESS.

    Anybody got any tools out there to do this conversion.
    Is it possible to convert structure and data without messing up.

    Access sucks and is my headache of the day.

    HELP!


Comments

  • #2
    egan007
    Registered Users, Registered Users 2 Posts: 2,934 ✭✭✭egan007


    They don't support an opensource database??????

    Sorry mate but I would advise getting a different host.


  • #3
    seamus
    Registered Users, Registered Users 2 Posts: 68,317 ✭✭✭✭seamus


    ODBC maybe.

    Get the ODBC Connector for MySQL, dump the contents of the database into an excel sheet or a series of excel sheets, then reimport them into an Access DB.

    As egan says though, I would reconsider what's going on. If you expect any sort of decent traffic on the site, an MS Access backend will seriously let you down.


  • #4
    layke
    Closed Accounts Posts: 1,956 ✭✭✭layke


    seamus wrote:
    As egan says though, I would reconsider what's going on. If you expect any sort of decent traffic on the site, an MS Access backend will seriously let you down.

    Agreed. Access is basically a big fat chunky database and I don't know why it's still used, anywhere.

    Can you not go with MS Sequel server at least?


  • #5
    phil
    Registered Users, Registered Users 2 Posts: 568 ✭✭✭phil


    Access isn't a real multi-user database it's more of data store. It's a pile of cack and I'd stay away from it if you want concurrent access without corruption / other problems.

    AFAIR even Microsoft do not recommend it for plenty of tasks (including web applications).

    Do yourself a favour and don't use it.


  • #6
    stakey
    Registered Users, Registered Users 2 Posts: 721 ✭✭✭stakey


    From http://msdn.microsoft.com/library/en-us/dnmsde/html/msdeforvs.asp

    "Jet can support up to 255 concurrent users, but performance of the file-based architecture can prevent its use for many concurrent users. In general, it is best to use Jet for 10 or fewer concurrent users."

    So if you're running an access database on a shared hosting infrastructure you can forget about stability.


  • Advertisement
Advertisement