D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] OOo database

 

Tony Sumner wrote:
> On Nov 21, 2006, Neil Stone was like:
> 
>> Or do it properly and export the Access data to a MySQL (or similar)
>> database... there is a MySQL ODBC driver available
>> (http://www.mysql.com/products/connector/odbc/) should you need it.
> 
> That looks like one called MyODBC. I think I am going to be able to do
> this. What I'm still not sure of is: do you suggest using MySQL as a
> replacement for Access, MySQL being free with optional 2000/yr for
> support, or is MySQL a stage in migrating the data into OOo Base?
> 
> Tony Sumner
> 
Well, you can either keep the database tables etc on a MySQL server for 
multi user access... (future plans ??) or, as it would appear is 
possible, import the data from MS Access directly in to OOoBase... it 
has support for this.

However I have had some odd results with this today, but I was using a 
very custom written database, with macros, custom reports etc..

If the database is not too wierd "it should just work" (tm)

HTH

Neil

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html