-
1. Re: database fro dir mx2004
> 1. Is ms access (w/datagrip Xtra) a good solution for this???
That depends on whether you already have a licence for an xtra that will
read mdb files. I would try to stay away from Access if possible as it's
Windows only.
> 2. since the data is flat, could i do this just with ms excel spreadsheet???
> Are spreadsheets searchable (a sadly ignorant question, i know)?
See above
> 3. considering the simplicity of the structure , yet the volume of text,
> should i even consider doing this as lingo lists?
Yes, I would use a list, or even a script member that returns the data
to you. Or perhaps a vList member/file. -
2. Re: database fro dir mx2004
I believe a SQLite databse will work nicely for your needs. You can read
about it here http://www.sqlite.org/
but all you really need is to download this awesome free Xtra by the
wonderful Valentin Shcmidt http://staff.dasdeck.de/valentin/xtras/sqlite/
Make sure you get the SQLite browser as well. -
3. Re: database fro dir mx2004
sean and dave
thanks to both.
it is good to have a compass ppointing north at the outset -
4. Re: database fro dir mx2004
Just a side comment, if you want simple, the Arca xtra works wonderfully well and can handle a large amount of data. The up side to using Arca is that you don't need to install anything on the user's computer. -
5. Re: database fro dir mx2004
thanks mathew
i have been up and down the db xtras and arca and valentina certainly look like the most serious products in terms of features and support. The problem is that, it now seems that the client needs to be able to update the db from time to time and it looks like they need a familiar environment - so ms access seems to be the answer.
as far as i understand arca won't swallow .mdb directly, so that´s out.
let me know if i am wrong and thanx again -
6. Re: database fro dir mx2004
As far as ease of editing goes, Arca is the way to go as well.
Download the editing tool... very simple. Also, Arca is built on SQlite, but with no install.
http://xtras.tabuleiro.com/download/arca.htm
If you can export your current database as an SQL file, Arca will import it. I love the Xtra. -
7. Re: database fro dir mx2004
As far as ease of editing goes, Arca is the way to go as well.
Download the editing tool... very simple. Also, Arca is built on SQlite, but with no install.
http://xtras.tabuleiro.com/download/arca.htm
If you can export your current database as an SQL file, Arca will import it. I love the Xtra.