Re: Re: Compacting a MS-Access database from perl

Access wants to be a frontend. And it works pretty good as a frontend. The major problem with Access is the database used as its backend (namely, Jet). Even Microsoft wants to ditch Jet (but that'll take a while, due to legacy apps). It is possible to use Access to a frontend to other databases, including MySQL, via ODBC.

While better than Jet (which isn't saying much), MySQL has other problems. It implements the bare-minimum requirements to be relational, and transactions are only kinda, sorta working. At least it can keep track of its own mind, which is something Jet doesn't do.

----
I wanted to explore how Perl's closures can be manipulated, and ended up creating an object system by accident.
-- Schemer

Note: All code is untested, unless otherwise stated

Comment on Re: Re: Compacting a MS-Access database from perl

Replies are listed 'Best First'.
Re: Re: Re: Compacting a MS-Access database from perl by Grygonos (Chaplain) on Jun 05, 2003 at 18:18 UTC
MySQL is my db of choice.. but this is corporate America and its not gonna happen... to make things worse... I don't technically work in the IT dept. here.. I'm fresh out of college witha BS in Computer Science and took the first job I got offered basically.. I do some gimpy work in which I find ways to incorporate perl, ruby , and java hehe... i found ole objects but can't find any good doc on them...	[reply]
Re: Re: Re: Re: Compacting a MS-Access database from perl by CountZero (Bishop) on Jun 05, 2003 at 18:48 UTC
Hey, don't complain. I'm a lawyer and working for a big American corporation in Belgium and doing a lot of IT work. We all use MS Office 97, but as soon as my applications started to outgrow Access, IT suggested to switch to Lotus Notes and having it done by IT in New York (as they are the only ones who hold the passwords to unlock the innards of Lotus Notes)! I countered by suggesting using Perl ("never heard of it"), Apache ("huh??") and MySQL ("database server, what's the difference with Access?") It took IT management more than six months to decide and then they only agreed because I already had the application (dynamic web-site) up-an-running on my laptop. So don't despair, just keep pushing or go ahead anyhow: chances are nobody will notice you run MySQL through Access as a front-end. CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]