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