Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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.

Looking for a Database Application which is free and doesn't run all the time.?

I used to work with MS Access and that'd be perfect for my project, but it costs money and I don't have any. I need to be able to reach the DB from outside of the application (server connect string hits IP.) This will be on Windows 7 and I will only be using it once every few weeks so I really don't want to install SQL Server Express which will run and bog down the machine a lot. Any ideas?

Update:

Somehow my message isn't getting across. I know how to connect to a DB, and I know that the DB has to be turned on. I don't want something like MSSQL which even when doing nothing will take up 40% of my CPU, same with MySQL. Access MDB's can be left inactive when I'm not using it, and I can have my script read/write to the DB when necessary. I'd also be fine with a DB that only runs when I want it (no auto-start on boot). It needs to be able to use an OBDC connection or something similar. I also need free, which rules out MSAccess.

3 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Have you looked into OpenOffice.org? The whole suite is free-ware and I hear they have a "clone" of MS Access available.

  • Anonymous
    1 decade ago

    If the database isn't running you can't connect to it. (It's like having the computer turn itself on at a certain time by having it run software - which it can't run until it's already turned on - a "you can't get there from here" situation).

    I'd use an Access .mdb file. Access the file remotely, using VB or some other language. The file doesn't "run", so it doesn't use CPU time.

  • 1 decade ago

    No database management software can be connected to unless it's running. However, as previously mentioned, you can connect to a mdb or similar database directly via ODBC or other connectivity protocols.

Still have questions? Get your answers by asking now.