Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

?
Lv 6

Can I use MS Access to build an online database?

If I use Access to build a fairly large database and upload it to a website, do I still have to learn SQL and all that? I'm sure SQL and other languages would help with making it fancier maybe, but are they completely and totally NECESSARY to having a functional database on a website?

Update:

The database is an MMO database to provide information for gamers.

4 Answers

Relevance
  • 9 years ago
    Favorite Answer

    Without SQL how are you intending to use the data in the database? You can not use VBA to do it on a web based database. So you might as well use SQL Server or MySQL.

    Source(s): VB.NET Programmer
  • Anonymous
    9 years ago

    Technically yes, you can use MS Access as your back end database but you will still need to know the SQL language in order to store and retrieve the data in your web application. MS Access is only good for low-traffic websites really, it's better to use MySQL.

  • Anonymous
    4 years ago

    this might or won't be the variety of tips you're searching for: ?to fasten the database (stay away from others from commencing the database together as you have it open)? Open the database From the Menu Bar: choose kit, then recommendations interior the verbal replace field that opens, choose the more advantageous tab click the unique decision (Radio Button under "Default open mode") ?To specify what's attainable to person(s)? Open the database From the Menu Bar: choose kit, then Startup A verbal replace field opens, allowing you to: coach/conceal the database window coach/conceal the status Bar Contol what menus and shortcut menus are attainable enable/Disable particular get entry to keys §

  • Anonymous
    9 years ago

    Yes but is less secure and slower than MS-SQL or MySQL

Still have questions? Get your answers by asking now.