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?

2010-12-16T23:23:12Z

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.

Capt Crasher2010-12-17T08:17:21Z

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.

Anonymous2010-12-16T11:09:27Z

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.

TheMadProfessor2010-12-16T12:18:03Z

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.