free software alternative to Access

Jason Stephenson jason at sigio.com
Mon Apr 18 19:17:01 EDT 2005


Jeff Smith wrote:
> 
> I should have used scalable instead of robust.  Ideally,the
> Access design tools would have been designed separately
> from the db engine. You plug in the db of your choice on
> the back  end.  Alas, I'm told you can do that, but I
> haven't met anyone who a) has done it, or b) can show /
> explain how to do it.

I've done it. It's relatively easy with ODBC. I've had an Access front 
end application that I created talk to a MS SQL Server 2000 database. 
You should be able to hook your Access front end up to any database 
server provided that you have an ODBC driver for your database. I know 
that they are available for MySQL, and most likely Prostgres as well. 
I've not used MySQL with Access but have used ODBC to connect to a MySQL 
server running on Linux from a Windows computer using a custom front end.

If you'd like some help with this, you can contact me off list.

Cheers,
Jason



More information about the gnhlug-discuss mailing list