Messages from Usenet group comp.lang.idl-pvwave, compiled by Paulo Penteado
You seem to be talking about apples and oranges. Access is a database product and IDL is a data analysis product. Probably the easiest thing to do is port the project to another database, not IDL. I'd recommend MySQL -- stable, fast, free. http://dev.mysql.com/tech-resources/articles/migrating-from- microsoft.html -Mike russ wrote: > Hi > > I have acquired an MS-Access databse program from someone else which i > need to modify/use. It has quite big files, does a few tens of sql > queries and outputs some results. The problems are, it often crashes, > works differently on different machines, is split up into n > subprograms because of filesize and memoery limitations and is overall > a bit of a mess. > > I was hoping to somehow rewrite in IDL. This should make it stable, > easier to debug, on Unix etc. Afterall, it is just manipulation of > matrices. > > Does anyone have any pointers or has tried this sort of thing before. > I have been using idl for a few years and have opened an access > database for the first time on monday. It seems to be a microsoft > nightmare. > > Thanks > > Russ
Yep, I know what you mean, but I think the thing should have been originally written in IDL. It is just applying algorithms to matrices. It was written by a guy who had no programming experience and so he used access. It has grown to become ridiculously unwieldy, whereas the algorithms are not that complex (but difficult to reverse engineer from looking at the database/tables and queries). russ > You seem to be talking about apples and oranges. Access is a database > product and IDL is a data analysis product. Probably the easiest thing > to do is port the project to another database, not IDL. I'd recommend > MySQL -- stable, fast, free. > > http://dev.mysql.com/tech-resources/articles/migrating-from- microsoft.html > > -Mike > > > russ wrote: >> Hi >> >> I have acquired an MS-Access databse program from someone else which i >> need to modify/use. It has quite big files, does a few tens of sql >> queries and outputs some results. The problems are, it often crashes, >> works differently on different machines, is split up into n >> subprograms because of filesize and memoery limitations and is overall >> a bit of a mess. >> >> I was hoping to somehow rewrite in IDL. This should make it stable, >> easier to debug, on Unix etc. Afterall, it is just manipulation of >> matrices. >> >> Does anyone have any pointers or has tried this sort of thing before. >> I have been using idl for a few years and have opened an access >> database for the first time on monday. It seems to be a microsoft >> nightmare. >> >> Thanks >> >> Russ