|
|
Posted by Tom Gahagan on 05/14/05 15:59
A google on....
Access to MySql
will yeild lots of good results to programs that will automate the data
conversion.
Best to you.......
Tom Gahagan
"Alan Searle" <aj_searle@xxxxyahoo.com> wrote in message
news:d628o9$92t$1@newsreader3.netcologne.de...
>> 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]
|