|
|
Posted by Alan Searle on 05/13/05 22:06
> Murphy wrote:
>
>> I am new to Linux and am migrating a SQL Server DB with an Access
>> front end to MySQL end ?
>>
>> What options are available under Linux for development of a client
>> front end
>> without copious amounts of programming.
>>
>> Without knowledge of PHP can a front end be developed using plugin
>> components with minimal fuss ?
This is a difficult one. I would say PHP via the browser is a good
option.
You could try looking at OpenOffice which includes a data driver for
MySQL. OpenOffice also includes a full scripting/Basic language and
form-painting tools (although I haven't looked to deeply into this).
I have heard of an 'Access-link' frontend called 'Rekall' ...
http://www.thekompany.com/products/rekall/
but I haven't tried it yet.
Or you could try leaving some functionality in MS-Access (on Window's
PCs) and only porting the main functionality to PHP (or whichever
frontend you choose for Linux. This would save some effort.
> Dr No wrote:
>
> Actually, I believe that with the right OBDC drivers you can connect
> Access to a MySQL database in much the same way you did SQL Server.
> Not
> knowing what you're trying to accomplish, I couldn't say if this is
> right for you, but I've read about it.
Yes, there is an ODBC driver for MySQL. It works fine with MS-Access
(just like Oracle and others). But I don't think this will help Murphy
because he/she is looking for a frontend that will run under Linux.
Navigation:
[Reply to this message]
|