OSS on Win32 app to replace MS Access?

[Ansar Mohammed]

#include <diaclaimer.h>

Hello Madison.
The trend that is promoted by most database vendors for *serious* app
development now is really to move away from file based solutions towards
client server (even if a local single user app is being developed).

I would most probably use SQL Server 2005 Express Edition as your backend;
which is free. It is a free version of SQL Server and can be used as a drop
in replacement for MS Access. If you want to migrate everything in MS Access
you can use the upsizing wizard and move everything over to SQL. After that
you can use any Win32 GUI development product to access the data once it is
in. SQL Server is really simple to setup/manage and it's quite quick.

Oracle and IBM have similar products called Oracle Express and DB2 Express
which are also free. Oracle and IBM also have tools to move from MS Access
called workbench and the DB2 migration toolkit respectively. I dunno much
about the IBM solution but both the Oracle and Microsoft products are
limited by 4gb of data, 1gb of memory and 1 CPU. I would assume that the IBM
product is similarly handicapped. 

Personally, both IBM and Oracle are a pain in the butt to setup and
configure; but they are very reliable products. I have only used DB2 as a
backend to IBM's LDAP server and it was a serious resource hog (but then
again it was on a VM with 256 MB of RAM and Win2k3..... lol). 

These products are not OSS but they sure are free. 
Have fun and good luck.




> -----Original Message-----
> From: owner-tlug-lxSQFCZeNF4 at public.gmane.org [mailto:owner-tlug-lxSQFCZeNF4 at public.gmane.org] On Behalf Of Madison
> Kelly
> Sent: April 13, 2006 4:54 PM
> To: tlug-lxSQFCZeNF4 at public.gmane.org
> Subject: [TLUG]: OSS on Win32 app to replace MS Access?
> 
> Hi all,
> 
>   Does anyone know of a free (oss ideally) app for windows that replaces
> MS Access? I've never used access so a plain google wouldn't really help
> me because I need something that works well. Anyone here have any
> experience/recommendations?
> 
>   Thanks all!
> 
> Madison
> 
> --
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
>           Madison Kelly (Digimer)
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> --
> The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
> TLUG requests: Linux topics, No HTML, wrap text below 80 columns
> How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml

--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml