1) Visual FoxPro (VFP) can ODBC to the existing Access Database. Not much
speed gain. Not quite what you are looking for but it might be a step.
2) Also, there is (some where) a program that can create a VFP Database from
an Access Database allowing you to gain much Much MUCH speed. Both data
speed and Rapid Application Development (RAD). Probably one to convert to
most any SQL flavor.
3) I know of a phoenix company that converted their Access Database to MS
SQL Server, keeping their Access programs and augmenting with VFP.
HTH,
George
> -----Original Message-----
> Date: Tue, 18 Apr 2006 11:38:43 -0700
> From: Nathan England <nathan@paysonlinux.org>
> Subject: Access alternatives
> To: "Phoenix-LUG, " <plug-discuss@lists.plug.phoenix.az.us>
> Message-ID: <200604181138.43346.nathan@paysonlinux.org>
> Content-Type: text/plain; charset="us-ascii"
>
>
> One of the departments in an organization I consult for recently
> requested a
> new server. I gave them several recommendations and they chose
> the more power
> system to my surprise, but with opted for RHEL4 instead of Windows 2003
> Server.
>
> Two weeks later, I have completed the integration/replacement of
> the Windows
> 2000 AD server with the RHEL4/Samba server. The integration was nearly
> flawless with only a few minor irritations I have yet to figure out. But
> throughout all this, I have had the corporate honchos watching what I am
> doing and have been impressed with the features of the server and
> things I
> can do with my laptop. Since many of them are having major
> spyware issues,
> which so far I am lucky to avoid being a consultant I am not to
> waste time on
> little projects... lol, I they are seeking a way to avoid all
> these problems.
> Throughout discussions on the server and why RHEL instead of
> Windows, they
> recall my mention of 'no spyware and few viruses' and they are
> curious about
> their desktops now. The entire orgranization uses word documents
> and excel
> spreadsheets, nothing advanced by any means, which OO.o could
> easily replace
> and some are already using it. The only problem however is the access
> databases, which there are MANY.
>
> Are there any ( I don't care free or not, just _ANY_ ) replacements or
> alternatives for Access databases?
>
> Nathan
> --
>
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)