[Gllug] Access Database to MySQL / PostreSQL

[Sean Burlington]

Bernard Peek wrote:
> In message <3EE9A224.2020007 at uncertainty.org.uk>, Sean Burlington 
> <sean at uncertainty.org.uk> writes
> 
>> Bernard Peek wrote:
>>
>>> In message <3EE89FD7.4000402 at harkness.co.uk>, Xander D Harkness 
>>> <xander at harkness.co.uk> writes
>>>
>>>> I have a few Access databases that are used to run a company's 
>>>> information flow.  (The whole company depends upon them)
>>>>
>>
>>>  Moving the data is almost trivially easy. But there is no usable 
>>> equivalent front-end that I've been able to find. I've asked in 
>>> several  places where I'd have expected someone to know.
>>>
>>
>> I'm curious, when you say front end - what do you mean ... ?
>>
>> are you talking about the forms that people might use after they have 
>> been created, the forms building tools - or some other aspect of M$ 
>> Access?
> 
> 
> It's not just the forms, but the code that makes them work.

you mean VBA ?

>>
>> The only times I have really used Access have been as part of an ASP 
>> project - when I've effecitivly been working from the command line 
>> anyway !
>>
>> The one thing I do really like about Access is the relationships tool ..
>>
>> It seems to me that Access is several packages in one, database 
>> server, visual development environment, report generator, database 
>> design tool..
> 
> 
> That's right. Whenever I've asked about replacements for Access I've had 
> suggestions that I use MySQL and a web-based front-end. I could do part 
> of the job with a database and a web server but not all of it. MySQL 
> wouldn't do the job because to do data validation you really need 
> triggers and probably stored procedures too.

the mysql argument is that you can do that data validation in the 
application

but have you looked at postrgresql ?

mysql is much better known but postgres is much more fully featured and 
does offer stored procedures


-- 

Sean



-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug