Flameless Advice Please...
Date: Mon, 3 Jan 2000 09:39:57 -0800
Message-ID: <84qmtf$sb6$1_at_news.NERO.NET>
[Quoted] Now I don't want some ranting session about the virtues of Oracle vs Access [Quoted] on this platform or that, but....
I've been developing a VB application (I'm not new to coding and don't like [Quoted] the lack of control that VBA allows) and have been having some problems with [Quoted] data corruption, and unpredictable behavior with Access VBA and would like [Quoted] to investigate using another database for (if it possible) performing small [Quoted] programming tasks instead of using ODBC (or something equivalent) for producing lots of data for a simulator. Basically, I'm running lots of simulations, storing the data in Access (using VBA) and exporting the crosstab queries to run in another piece of software. Usually, I delete all [Quoted] the rows from the tables and repopulate with over 1000000 records. My database files (mdb) are about 120mb which is much larger than they should [Quoted] be even after compacting and my NT machine keeps telling me that I've run out of virtual memory. I need this thing to be not just good but VERY reliable because I can't stand up in court and say, "MSAccess wasn't doing [Quoted] what it was told."
[Quoted] So I guess my questions are (and not knowing anything about Oracle):
- Does Oracle have some kind of VBA language?
- Can Oracle call DLLs with user defined data types?
- Does Oracle run under NT and Linux equally well?
Thanks for the flameless advice,
Jeff.
-- Jeff D. Hamann 2601 NE Jack London Street #27 Corvallis, Oregon 97330 USA 541-740-5988 hamannj_at_ucs.orst.edu http://ucs.orst.edu/~hamannjReceived on Mon Jan 03 2000 - 18:39:57 CET